Excel: the boolean data type

When involved in a mathematical expression, TRUE is considered to be 1 and FALSE to be 0.

Thus, with minus minus (--), a boolean value can be turned into a numerical representation.

Worksheet functions:

• type(value) returns 4 for logical values.
• if(…) returns a different value depending on the truthness of a given value
• true() and false() return TRUE and FALSE, respectively

Excel data types