The general syntax for an if-then formula is: IF(logical_test, [value_if_true], [value_if_false]) For example: IF(A1>5, "Yes", "No") This formula will check if the value in cell A1 is greater than 5 and return "Yes" if it is, and "No" if it isn't.