Abstract
Transcript
In this video, well introduce the idea of boolean values in Excel.
A boolean is a data bang out with only two possible values.
In Excel, these are the logical values TRUE and FALSE.
Youll notice that Excel treats TRUE and FALSE in a special way.
If I key in the word true in lowercase, Excel automatically capitalizes it.
The same thing happens if I pop in false.
Note also that Boolean values are automatically centered in the cell.
Excel actually has a function called ISLOGICAL that will test for the boolean values TRUE and FALSE.
All other values return FALSE.
A Boolean expression is a logical statement that returns TRUE or FALSE.
Boolean expressions are also called logical expressions.
For example, 5>3 is a boolean expression that returns TRUE.
5>10 is a boolean expression that returns FALSE.
Boolean expressions in Excel often use cell references.
D7=apple returns TRUE, and D7=orange returns FALSE.
Boolean expressions can use all available math operators.
They can also make use of other functions.
TheISEVENfunction here returns TRUE because 100 is an even number.
The formula in H12 returns TRUE because the year of the date in D10 is 2021.
Its common to see boolean expressions inside other formulas.
Because the result is TRUE, IF returns “Pass”.
The same formula in L8 returns “Fail”.
The formula in L9 tests if J9 is greater than 200.
If TRUE, the result is J9 multiplied by 5%.
If FALSE, the value in column J is multiplied by 3%.
Finally, note that Excel will evaluate numeric values as Booleans on-the-fly when needed.
