Exago Logo
Search
Generic filters
Exact matches only

Logical Functions

Logical functions can be used to handle conditional information.

And

DescriptionReturns TRUE if all its arguments are TRUE; returns FALSE if any argument is FALSE.
RemarkThe arguments must evaluate to TRUE or FALSE.

NOTE. The And function can take more than two arguments as input.

ExampleEx. AND(2+2=4, 4+0=4, 2+3=6) – returns FALSE.False:

False

DescriptionReturns the logical value FALSE.
RemarkYou can also type the word FALSE directly onto the worksheet or into a formula; it is interpreted as the logical value FALSE.
Example

If

DescriptionTakes three arguments as input. Returns the second argument if the first evaluates to TRUE. Otherwise returns the third argument.
RemarkThe first input must evaluate to TRUE or FALSE.
ExampleEx. if({OrderDetail.Price}= 0,’FREE’,{OrderDetail.Price}) – returns FREE if the price is 0, otherwise it returns the price.

Not

DescriptionReverses the value of its argument.
RemarkArgument should evaluate to TRUE or FALSE.
ExampleEx. Not(FALSE) – returns TRUE.

Or

DescriptionReturns TRUE if any argument is TRUE.
RemarkThe arguments must evaluate to logical values such as TRUE or FALSE.

NOTE. The ‘Or’ function can take more than two arguments as input.

ExampleEx. OR(2+2=4, 4+0=8, 2+3=6) – returns TRUE.

Switch

DescriptionThis function should be used instead of placing if() functions inside of if() functions.

Takes any even number of inputs arguments.

RemarkThe 1st argument will be the test value to compare to.

The 2nd argument will be returned if none of the comparisons return true.

The 3rd, 5th, 7th… arguments will be compared to the 1st argument. When the first match occurs the following argument will be returned.

For example if argument 3 matches argument 1 then the 4th argument will be returned.

ExampleEx. Switch({Categories.CategoryName},”NOT FOUND”, “Beverages”, “Drink up!”, “Condiments”, “Enhance”, “Confections”, “Sweet Tooth”) – returns a string based on the Category Name.

True

DescriptionReturns the logical value TRUE.
RemarkYou can also type the word TRUE directly onto the worksheet or into a formula; it is interpreted as the logical value TRUE.
Example
Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Table of Contents