Question

What function lets you test if something is true or false and then do different things depending on which result you get? (include the = and (), but don't need to include the conditions)

Answer 1

The function you're referring to is the `IF` function. It is used to test a condition and perform different actions based on whether the condition is true or false. The syntax is as follows:

```
=IF(condition, value_if_true, value_if_false)
```

In this function, you would replace `condition` with your specific condition to test, `value_if_true` with what you want to happen if the condition is true, and `value_if_false` with what you want to happen if the condition is false.