IF only

In Data Analysis in Google Sheets, you learned how to use IF() function. IF() takes a logical condition as its first input, so it is often used in conjunction with NOT(), AND() and OR().

To recap, it takes three arguments: the logical condition, a value to return if the condition is met, and a value to return if the condition is not met.

One common usage is to make the second and third arguments text values, to convert a logical condition into text status labels: =IF(logical_condition, "status 1", "status 2").