Logische Funktionen

Top  Previous  Next

Name

Description

Syntax

AND 



Returns TRUE if all of its arguments are TRUE; returns FALSE if one or more arguments evaluate to FALSE.

AND(logical1, [logical2], …)

FALSE 


Returns the logical value FALSE.

FALSE()

IF 


Checks a condition and returns one result if the condition is TRUE, and another result if the condition is FALSE.

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

IFS 


Checks one or more conditions and returns a value of the first TRUE condition. If no TRUE conditions are found, this function returns #N/A error.

IFS([logical_test, value_if_true, ,…)

IFERROR 


Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.

IFERROR(value, value_if_error)

IFNA 


Returns a value you specify if a formula returns the #N/A error value; otherwise it returns the result of the formula.

IFNA(value, value_if_na)

NOT 


Reverses the logical value of its argument.

NOT(logical)

OR 


Returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.

OR(logical1, [logical2], …)

SWITCH 


Evaluates an expression against a list of values and returns the result of the first matching value. You can provide a default value to return if there is no match. If there are no matching values and no default argument is supplied, the function returns the #N/A! error.

SWITCH(expression, value1, result1, default_or_value2, result2,…)

TRUE 


Returns the logical value TRUE.

TRUE()

XOR 


Returns a logical exclusive OR of all arguments.

XOR(logical1, [logical2],…)