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

Check if cell value meets condition

IF with only two arguments (defaults to FALSE)

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

---

← Back to Formula Reference