IF

The IF formula is used to perform a logical test and return one value if the test is true, and another value if the test is false. To use the IF formula, select the cell where you want the result to appear and enter “=IF(” followed by the logical test, the value to return if the test is true, and the value to return if the test is false. For example, “=IF(A1>5,”Yes”,”No”)” would return “Yes” if the value in cell A1 is greater than 5, and “No” if it is not.

Example:

If the value in cell A1 is greater than 5, return “Yes”, otherwise return “No”: =IF(A1>5,”Yes”,”No”).