In this video, I’m going to show you the basics of boolean logic. Boolean logic is a great tool for simplifying formulas, especially those with many IF statements.
So, to start off, what’s a boolean?
A boolean is a data type with only two possible values, TRUE or FALSE.
You’ll often see boolean results, or boolean expressions in Excel.
For example, if I enter the formula =B4>30 here, we’ll get the boolean result TRUE.
So, B4>30 is a boolean expression – or logical statement – that returns TRUE or FALSE.