The most basic example of Boolean logic in action is the IF function in Excel.
Recall that we could set up a formula where we test each salesperson’s sales figures.
That can output the correct commission based on a TRUE or FALSE outcome.
In the previous figure, note that we have an IF formula that tests the sales total values. It tests that against the value in cell B4 ($2,000).
If the sales total figure is greater than $2,000, the IF formula results in TRUE.
This is the second argument of the formula where we have placed the cell reference $C$4.
If the logical test comparing the sales total to the benchmark is TRUE, we want 15% to be the result of the formula.
If the formula evaluates to FALSE (meaning the sales total is less than $2,000), the formula will result in 10%.
This is a quick example of how common Boolean logic factors into formulas in Excel.
So, it is a good idea to understand as much about the nature of TRUE and FALSE in a wide context.