HAELSŐIGAZ

IFS is a multiple IF-function.

Szintaxis

IFS(expression1; result1[; expression2; result2][; ... ; [expression127; result127]])

expression1, expression2, ... are any boolean values or expressions that can be TRUE or FALSE

result1, result2, ... are the values that are returned if the logical test is TRUE

IFS( expression1, result1, expression2, result2, expression3, result3 ) is executed as

HA kifejezés1 IGAZ

AKKOR eredmény 1

EGYÉBKÉNT HA kifejezés2 IGAZ

AKKOR eredmény 2

EGYÉBKÉNT HA kifejezés3 IGAZ

AKKOR eredmény 3

To get a default result should no expression be TRUE, add a last expression that is always TRUE, like TRUE or 1=1 followed by the default result.

If there is a result missing for an expression or is no expression is TRUE, a #N/A error is returned.

If expression is neither TRUE or FALSE, a #VALUE error is returned.

Technikai információk

Ez a funkció a LibreOffice 5.2 óta érhető el.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.IFS

IFS wiki page.

ÁTVÁLT