Convert Boolean TRUE/FASLSE to integer in Mac Numbers

If I perform a comparison in Mac Numbers, the result is either “TRUE” or “FALSE”. In many situations, I want to see an integer value instead. For example, the integer value equivalent to “TRUE” boolean value is 1. And the “FALSE” boolean value is equivalent to 0. How do I convert the boolean values to integers?

Mac Numbers by default understands a “TRUE” value is 1, and a “FALSE” value is 0. It just doesn’t display 0 or 1. In order to do so, you simply multiply your boolean value with 1. If your condition returns a “TRUE” value, then the formula “TRUE * 1” is equivalent to “1 * 1 = 1”. Similarly, when you have a “FALSE” value, the formula “FALSE * 1” is equivalent to “0 * 1 = 0”. Now the screen will display 1 or 0 instead of true or false.  

The only downside is that you can see the blue mark at the corner of the cell where you do the multiplication between a boolean value and 1. The blue mark is just a harmless warning. It will tell you, “The formula uses a Boolean in place of a number”. Unfortunately, there is no way to hide that warning.   

Luckily, the warning won’t show if you print out your sheet. It means you won’t see the warning on paper or on the PDF file. You only see the blue mark warning on the Mac Numbers screen.