The IF function allows you to perform conditional logic tests on your data. It follows the syntax =IF(condition, value_if_true, value_if_not_true).

For instance, =IF(A1>10, “High”, “Low”) checks if the value in A1 is greater than 50. If true, it returns “High”; otherwise, “Low”.