How To Use Logical Expressions In Other Calculated Expressions?
9 Dec 2019 / 1 minute to read
Logical expressions return a True or False value. If you use a logical expression as part of a calculation, then,
- A True is replaced with 1.
- A False is replaced with 0 as the whole expression is evaluated.
This allows you to easily write and compute formulas that involve logical conditions.
Consider the following expression:
([Cost] < 100) * 1 + ([Cost] >= 100) * ([Cost] < 200) * 3 + ([Cost] >= 200) * ([Cost] < 300) * 5 + ([Cost > 300) * 7
Depending upon the value of cost, this expression returns 1, 3, 5 or 7. This is an example of using a linear combination of logical expressions that times other values.
NOTE
The logical conditions are mutually exclusive, but, when taken as a whole, cover all possible values of cost. It has the effect of assigning a unique value depending upon the input value.
Was this page helpful?
Yes
No
Thank you for your feedback!
Thank you for your feedback and comments. We will rectify this as soon as possible!
An unknown error has occurred. Please try again.
Help us improve this page