value_if_false (optional) - the value to be returned if the logical test evaluates to FALSE, i.e.if the condition is met.įor example, the following formula will return the text 'Good' if a value in cell B1 is greater than 10: =IF(B1>10, 'Good') value_if_true (optional) - the value to return when the logical test evaluates to TRUE, i.e.In this argument, you can specify a text value, date, number, or any comparison operator.įor example, your logical test can be expressed as or B1='sold', B110. logical_test (required) - a value or logical expression that can be either TRUE or FALSE.IF(logical_test,, )Īs you see, the IF function has 3 arguments, but only the first one is obligatory, the other two are optional.
