6.2 The "IF" function

Last edited 481 days ago by Makiel [Muh-Keel].

The IF function builds on Boolean logic to help you construct flexible formulas. The syntax of the IF function is below. The IF statement accepts three arguments.

The first is a Boolean expression (logical_test) comparing two values. The other two arguments are used to specify the results of the function depending on the results of the Boolean expression.

The second argument (value_if_true) is used to specify the result of the IF function if the Boolean expression result is TRUE.

The third argument (value_if_false) is used to specify the result of the IF function if the Boolean expression is FALSE.

=IF(logical_test,[value_if_true],[value_if_false])

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.