Summary
In this video, we are looking at how Excel handles TRUE and FALSE values.
Tab in example file: Understanding truth
TRUE and FALSE are are logical values, they are not text.
In arithmetic calculation, TRUE and FALSE are automatically converted to 1 or 0.
Any non-zero number is deemed to be TRUE, and zero is deemed to be FALSE.
Text does not have TRUE or FALSE properties.
Multiplication of TRUE / FALSE values creates AND type logic.
Addition with TRUE / FALSE values create OR type logic.