IF function syntax

IF function syntax:-

Any value or expression that you want to evaluated for TRUE or FALSE. 

If the evaluated value or expression is met then it returns a value for TRUE.

Else it returns another value that’s for FALSE.

Syntax :

IF(logical_test, [value_if_true], [value_if_false])

The following are the arguments for above syntax function.

Logical_Test (Required):- Any value or expression that can be evaluated for True or False.

Value_if_true (optional):- Any value that you want to return if the logical_test that you evaluated is met is for TRUE. If you omitted then it returns a value 0 (zero).

Value_if_false (optional):- Another value that you want to return if the logical_test that you evaluated is not met is for FALSE. If you omitted it returns a value 0 (zero). 

Note: If you omitted it after placing the second comma then it returns 0 (zero).

IF(logical_test,[value_if_true],) – it returns value 0 if the logical_test is not met. For FALSE argument.

And if you omitted it without placing a second comma then it returns FALSE. 

IF(logical_test,[value_if,true]) - it returns value FALSE if the logical_test is not met. For FALSE argument.