IF

You are here:
Function name IF
Type Logical
Arguments – test
– then_value
– otherwise_value
Syntax =IF(test, then_value, otherwise_value)
Description Checks whether a condition is met and returns one value if true and another value if false.

The Arguments description:

  1. test – a value or logical expression that is to be evaluated.
  2. then_value – the value to return when test evaluates to TRUE.
  3. otherwise_value – the value to return when test evaluates to FALSE.

Examples:

=IF(C6<50,"FX",IF(C6<55,"UD",IF(C6<75,"JC",IF(C6<1055,"QR","YV"))))

IF function