Home |
What is boolean query? |
[Improve]
A boolean query is a query that uses a boolean conditional.
E.g., an overtime formula would be
(hours-40)(hours>40)
The boolean expression would multiply the first result by 1 if hours is greater than 40, and, by 0 otherwise. This would prevent a negative overtime calculation.
The result would be the same as
=if(hours>40, hours-40,0)
krazykyngekorny(at)gmail.com
E.g., an overtime formula would be
(hours-40)(hours>40)
The boolean expression would multiply the first result by 1 if hours is greater than 40, and, by 0 otherwise. This would prevent a negative overtime calculation.
The result would be the same as
=if(hours>40, hours-40,0)
krazykyngekorny(at)gmail.com
First answer by ID1202039075. Last edit by ID1202039075. Question popularity: 1 [recommend question]
