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:
- test – a value or logical expression that is to be evaluated.
- then_value – the value to return when test evaluates to TRUE.
- 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"))))