Documentation/Calc Functions/IF

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

IF

Category:

Logical

Summary:

Specifies a logical test to be performed.

Syntax:

IF(Test; ThenValue; OtherwiseValue)

Returns:

It return the values that are given in the expression according to the condition being TRUE or FALSE.

Arguments:

Test is any value or expression that can be TRUE or FALSE.

ThenValue (optional) is the value that is returned if the logical test is TRUE.

OtherwiseValue (optional) is the value that is returned if the logical test is FALSE.

In the LibreOffice Calc 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 marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone.

Additional details:

Examples:

=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.

If.png

Related LibreOffice functions:

OR

AND

ODF standard:

Section 6.16.4, Part 2

Equivalent Excel functions:

IF[1]