Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.
Description
How To Use in Sheets
IF(logical_expression, value_if_true, value_if_false)
External Links
How to Make an Interactive To Do List In Google Sheets
Imagine this kind of to-do list: Any time we check off one of our chores in our list, the text changes to something that shows us what we’ve done. Instead of just a checkbox, the text actually changes.
Automate Google Sheets without Apps Script, without Zapier
Automate Google Sheets without Apps Script, without Zapier. Using a few Google Sheets formulas you can bring automation-esque actions to your sheets. Using these 6 formulas (2 formulas and 2 formula pairs) you can make pure magic inside your sheets. Without learning apps script, and without using a 3rd party automation like Zapier.
21Better Sheets Tutorials
20