FUNCTION CATALOGUE / LOGICAL
IF Excel function
Returns one result if a condition is true and another if false.
Correct sentence to use
If [condition], return [true result], otherwise return [false result].
Modify this query in PlainFormula →Example formula
=IF(A2>100,"High","Low")
Tests a condition and returns one of two results.
Syntax
IF(logical_test, value_if_true, [value_if_false])
Argument signature: logical_test, value_if_true, [value_if_false]
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.