Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.
Sample Usage
IF(A2 = "foo","A2 is foo")
IF(A2,"A2 was true","A2 was false")
IF(TRUE,4,5)
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
orFALSE
. -
value_if_true
- The value the function returns iflogical_expression
isTRUE
. -
value_if_false
- [ OPTIONAL - blank by default ] - The value the function returns iflogical_expression
isFALSE
.
Notes
- Ensure that
value_if_true
andvalue_if_false
are provided to the function in the correct order - this is the single most common source of problems withIF
.
See Also
- IFERROR: Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent.
- IFS: Evaluates multiple conditions and returns a value that corresponds to the first true condition.
Examples
Specifies a logical test to be performed.