Logical Formulas in WinForms Calculation Engine (Calculate)
13 Jul 20214 minutes to read
AND
Returns true
when all the arguments have a logical value of True
and returns false
when at least one argument is False
.
Syntax:
AND(logical1, logical2, …)
where:
 logical1, logical2 … are multiple conditions to be tested for
true
orfalse
.
Remarks:

The arguments must evaluate to logical values (True or False).

When an argument does not evaluate to True or false, those values are ignored.

There must be at least one value in the argument list.
FALSE
The False
function returns the logical value for the false
.
Syntax:
FALSE(stringvalue)
where:
 stringvalue is to provide an empty string.
IF
Returns one value when a condition you specify evaluates to True
and another value when it evaluates to False
.
Use If
to conduct conditional tests on values and formulas.
Syntax:
IF(logical_test, value_if_true, value_if_false)
where:

logical_test is any value or expression that can be evaluated to
True
orFalse
. 
value_if_true is the value that is returned if a logical_test is
True
. 
value_if_false is the value that is returned if a logical_test is
False
.
Remarks:
 Countif and Sumif are additional methods that provide conditional calculations.
IFERROR
IfError
function tests when an initial given value (or expression) returns an error, and then, this function returns a second given argument. Otherwise, the function returns the initial tested value.
Syntax:
IFERROR (value, value_error)
where:

value
is the required to check the error. 
value_error
is the required and returns when the value has an error. 
When the value_error is an empty cell, then the function takes the error value as empty string.
IFNA
IFNA
function returns the value specified when the formula returns the #N/A error value; otherwise, it returns the result of the given formula.
Syntax:
IFNA (Formula_value, value_if_na)
where:

Formula_value
: This value is required and the argument that is checked for the #N/A error value. 
value_if_na
: This value is required and the value returned when the formula evaluates to the #N/A error value.
NOT
The Not
function reverses the value of its argument.
Syntax:
NOT(logical)
where:
 logical is a value or expression that can be evaluated to
True
orFalse
.
TRUE
The True
function returns the logical value for True
.
Syntax:
TRUE(stringvalue)
where:
 stringvalue is to provide an empty string.
OR
Returns True
when any argument is True
returns False
when all arguments are False
.
Syntax:
OR(logical1, logical2, …)
where:
 logical1, logical2 … are conditions to test that can be either
True
orFalse
.
Remarks:
 The arguments must evaluate to logical values such as
True
orFalse
or in arrays or references that contain logical values.
XOR
XOR
function returns the exclusive OR
for the given arguments.
Syntax:
XOR (logical_value1, logical_value2…)
where:

Logical_value1: This is a required value and can be either
true
orfalse
, and can be logical values, arrays, or references. 
When the given arguments do not have the logical values,
XOR
returns the#VALUE!
error value.
IFS
The IFS
function runs multiple test, and returns a value that corresponds to the first TRUE condition. IFS
can take the place of multiple nested IF statements, and is allows shorter, easier to read formulas.It used to test multiple conditions and return first true result.
Syntax:
IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], [logical_test3, value_if_true3],…)
where:

logical_test1 (required): This is the first logical test that evaluates to
TRUE
orFALSE
. 
value_if_true1 (required): Result to be returned if the first logical test (logical_test1) evaluates to
TRUE
.This Can be empty string. 
logical_test2…logical_test127 (optional):This is the second logical test that evaluates to
TRUE
orFALSE
. 
value_if_true2…value_if_true127 (optional): Result to be returned if logical_testN evaluates to
TRUE
. Each value_if_trueN corresponds with a condition logical_testN.This Can be empty string.
Remarks:

To specify a default result, enter
TRUE
for your final logical_test argument. If none of the other conditions are metTRUE
, the corresponding value will be returned. 
The argument (logical_test) is supplied without a corresponding value_if_true, this function shows a
You've entered too few arguments for this function
error message. 
The argument (logical_test) is evaluated and resolves to a value other than
TRUE
orFALSE
, this function returns a#VALUE!
error message. 
If no
TRUE
value found, this function returns#N/A
error message.
SWITCH
The SWITCH
function compares one value against a list of values, and returns the result corresponding to the first match.It return default value when there is no match found.
Syntax:
SWITCH(expression, value1, result1, [default or value2, result2],…[default or value3, result3])
where:

expression(required): The value or expression (number, date or some text) that will be compared against list of values.

value1…value126: This is a list of values that will be compared against expression.

result1…result126: ResultN is the value to be returned when the corresponding list of values matches expression. ResultN and must be supplied for each corresponding valueN argument.

default (optional):Default is the value to return in case no matches are found when compare the list of values against expression. The Default argument is identified by having no corresponding resultN expression. Default must be the final argument in the function.