IF function

IF specifies a logical test to be performed.


IF(test,then value,otherwise value)

In IBM Docs functions, parameters marked as optional can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are optional, you can leave out parameter 4 or parameters 3 and 4. However, you cannot leave out parameter 3 alone.


=IF(A1>5,100,"too small")

If the value in A1 is higher than 5, the value 100 is entered in the current cell; otherwise, the text "too small" (without quotes) is entered.

Trademarks | IBM Connections wiki