answersLogoWhite

0

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

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is an example of a boolean search?

Going into Google and typing a search query which includes "something AND something"


What is a example of a Boolean search?

Going into Google and typing a search query which includes "something AND something"


What is the difference between an ''or'' query and an ''and'' query?

It is the same difference between an OR Boolean and AND Boolean. In an OR query, you are looking for something that matches one of several possible values, while in an AND query, you are looking for something that matches all of several possible values. -- Find the first name of anyone in the USA, or have a last name starting with A. SELECT FirstName FROM Contacts WHERE Country = 'USA' OR LastName LIKE 'A%' -- Find the first name of anyone in the USA that also has a last name starting with A SELECT FirstName FROM Contacts WHERE Country = 'USA' AND LastName LIKE 'A%' The difference between these two is that the first one will return people outside the USA if their last name starts with an A, while in the second query, only people inside the USA with the last name starting with A will be returned. AND will always return the same or fewer values than OR.


Which boolean operation is referred to as a boolean product?

AND operation is referred as a boolean product


If Eat Hamburger?

AND boolean


The definition of a boolean operator?

what is boolean operator


Which boolean operator omits information from the search parameters?

The boolean operator that omits information from the search parameters is the NOT operator. When used in a search query, it excludes specific terms, helping to refine results by filtering out unwanted content. For example, searching for "cats NOT dogs" will return results related to cats while excluding any mentions of dogs.


What year did George Boole develop boolean algebra?

what is the contribution George Boolean to the development of Boolean operations


What is a boolean variable?

A Boolean variable is a variable from Boolean algebra having one of only two values.


Who invented boolean?

George W. Boolean. AK


What is a Boolean indicator?

it is a thing that indicates that a boolean is close


What is boolean data type?

what is boolean data type