# Documentation/Calc Functions/IFS

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

IFS

## Category:

Logical

## Summary:

IFS is a multiple IF-function.

## Syntax:

IFS( **expression1**, **result1**[, **expression2**, **result2**][, …] )

## Returns:

## Arguments:

**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

IF expression1 is TRUE

THEN result1

ELSE IF expression2 is TRUE

THEN result2

ELSE IF expression3 is TRUE

THEN result3

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.