IF

Returns one value if condition is true, another if false.

Excel: Verified match
Google Sheets: Verified match
Returns: Any value

Examples

=IF(A1>100, "High", "Low")

	A
1	10

Result Low

=IF(A1>5, B1, 0)

	A	B
1	10	2

Result 2

Syntax

IF(condition, value_if_true, [value_if_false])

condition: boolean required
value_if_true: any required
value_if_false: any optional

ANDReturns TRUE if all arguments are true. EQTrue when two values are equal. FALSEReturns the logical value FALSE. GTTrue when the first number is greater. GTETrue when the first number is greater or equal. IFERRORReturns value if no error, otherwise alternate.