Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

Logical Functions

  • 2 minutes to read

This document describes logical functions supported by the WinForms Spreadsheet control.

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],…)
See Also