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 ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.