Returns one value if a logical expression is 'TRUE' and another if it is 'FALSE'.
SYNTAX: =IF(logical_expression, value_if_true, value_if_false)
logical_expression - An expression or reference to a cell containing an expression that represents some logical value, i.e. 'TRUE' or 'FALSE'.
value_if_true - The value that the function returns if 'logical_expression' is 'TRUE'.
value_if_false - The value that the function returns if 'logical_expression' is 'FALSE'.
PRACTICE SHEET
The below sheet is view only mode, please make a copy to practice.