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)
Convert TRUE and FALSE values to 1 and 0 in Excel
Journey in work with data
Journey in work with data
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”