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 or false.

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 or False.

  • 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 or False.

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 or False.

Remarks:

  • The arguments must evaluate to logical values such as True or False 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 or false, 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 or FALSE.

  • 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 or FALSE.

  • 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 met TRUE, 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 or FALSE, 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.