IF function

Description

This IF function is a logical function to return one value for a TRUE result and alternatively FALSE result. For example, "pass" scores above 70:=IF(A1>70,"Pass","Fail"). If there are more than one condition, nested IF could be used. It is also able to work with other logical function like AND and OR.

​

Objective

Testing the logic and return TRUE or FALSE as the result.

​

Syntax

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

​

Arguments

logical_test - logical expression could be evaluated as TRUE or FALSE.

value_if_true - [optional] value to return when logical_test evaluates to TRUE.

value_if_false - [optional] value to return when logical_test evaluates to FALSE.

​

​