## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

# IF()

Syntax. IF(logical_test,value_if_true,value_if_false)

Definition. This function checks a logical condition and performs the first action specified after the test argument if the condition is true and the second action if it is false.

Arguments

• logical_test (required). Any value or expression that can be evaluated to TRUE or FALSE

This argument can use any comparison operator:

• Equal sign (=). You can directly compare the content of a cell with a number (A1=7), or you can compare two cells (A1=B1).

• Greater than (>) or less than (<). You can directly compare the content of a cell with a number (A1>7 or B1<8), or you can compare two cells (A1>B1 or C1<D1).

• Greater than or equal to (>=), less than or equal to, (<=), or not equal (<>). The not equal sign ...

## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

No credit card required