Explanation
This formula usesboolean logicto output a conditional message.
If the value in column C is less than 100, the formula returns “low”.
If not, the formula returns an empty string ("").
Boolean logic is a technique of handling TRUE and FALSE values like 1 and 0.
IF function alternative
Conditional messages like this are more commonly handled with the IF function.
Extending the logic
Boolean logic can be extended with simple math operations to handle more complex scenarios.
A simple way to do this is to use adouble-negative(–).
For example, =REPT(“x”,5) returns “xxxxx”.
More than one condition can be tested by nesting IF functions.
AND returns TRUEonly if all the conditions are met.
If any conditions are not met, the AND function returns FALSE.
The AND function is commonly used with other…
Related videos
Intro to Boolean Logic
