Excel

Convert TRUE and FALSE values to 1 and 0 in Excel

by Janis Sturis
June 18, 2020
Comments 0

Here is a simple trick that is not so obvious. By adding two minus signs before calculation, you can convert TRUE, FALSE into 1, 0 in Excel.

=--(A2=B2)

0 comments on “Convert TRUE and FALSE values to 1 and 0 in Excel”

Leave a Reply

Your email address will not be published. Required fields are marked *