IF

Returns the first value if logical_expression is TRUE; otherwise returns the second value.

Syntax

IF(logical_expression, value_if_true, [value_if_false])

Arguments

Argument Description Required
logical_expression A logical expression or a value that can be evaluated as TRUE or FALSE. Required
value_if_true The value to return if logical_expression evaluates to TRUE. Required
value_if_false The value to return if logical_expression evaluates to FALSE. Optional

Examples

Simple true/false comparison

=IF(5 > 3, "Yes", "No")

Result ⇒Yes

Check if cell value meets condition

=IF(A1 >= 90, "A", "B")

Result ⇒B
A
1 85

IF with only two arguments (defaults to FALSE)

=IF(A1 > 200, "High")

Result ⇒false
A
1 100

Related Functions

Other Logical functions:

  • AND - Returns true if all arguments evaluate to true
  • CONTAINS - Returns true if a range contains a specified value
  • IFERROR - Returns a custom result when a formula generates an error, and a normal result when no error is detected.
  • IFS - Returns the value corresponding to the first TRUE result when evaluating multiple tests.
  • ISBETWEEN - Returns true if a provided number is between two other numbers either inclusively or exclusively; otherwise returns false.
  • ISBLANK - Returns true if the value is blank, empty, or null; otherwise returns false.
  • ISERROR - Returns TRUE if the value is any error value
  • ISEVEN - Returns TRUE if the number is even, FALSE if odd
  • ISNA - Returns TRUE if the value is the #N/A error value
  • ISNUMBER - Returns TRUE if the value is a number
  • ISODD - Returns TRUE if the number is odd, FALSE if even
  • ISTEXT - Returns TRUE if the value is text
  • NOT - Returns FALSE if logical expression is TRUE and TRUE if logical expression is FALSE.
  • OR - Returns true if any argument evaluates to true
  • SWITCH - Evaluates an expression against a list of values and returns the result corresponding to the first matching value. Optionally returns a default value if no match is found.
  • XOR - Returns TRUE if an odd number of arguments are TRUE, and FALSE otherwise