Using IF in Excel

IF function is used to conduct an evaluation of whether a value or formula is TRUE or FALSE.

The function allows user to specify the outcome of TRUE and FALSE.

For example, if the value of reference cell is TRUE, execute formula A, if the value of reference cell is FALSE, execute formula B.

=IF(logical_test, outcome if TRUE, outcome if FALSE)

logical_test can be any value or argument which will be evaluated as TRUE or FALSE. This is very much like a condition, if condition is met then TRUE else FALSE.

Therefore, in the above formula, if logical_test is TRUE, execute “outcome if TRUE”, else execute “outcome if FALSE”.

An example, assuming cell A2 is “110” and cell A3 is “104”

=IF(A2>100,”Greater than 100”,”Less than 100”)

The result of the above formula will be “Greater than 100”

=IF(A3>110,”Greater than 110”,”Less than 110”)

The result of the above formula will be “Less than 110”.

Keyword: Logical