Courses
IF Function
Return value
Returns second argument if the condition is met else it returns third argument.
Syntax
= IF(logical_test; [value_if_true]; [value_if_false])
Arguments
| Argument | Description |
|---|---|
| logical_test | Logical test that must be TRUE or FALSE. |
| [value_if_true] | [Optional]: Value to return if logical_test is TRUE. |
| [value_if_false] | [Optional]: Value to return if logical_test is FALSE. |
Remarks
The IF Function makes other Logical Functions useful as it lets you control cell output based on a logical test. The most common use of AND, OR, XOR and NOT is in combination with IF. Results of TRUE or FALSE from AND, OR, XOR and NOT is often not on its own enough to solve complex business problems.