How to Convert the True and False Values to 1 and 0 in MS Excel

Quick summary

In Microsoft Excel, you can convert TRUE and FALSE values to 1 and 0 by wrapping a logical formula in parentheses and prefixing it with a double unary operator (--). This technique lets Excel treat Boolean results as numeric values, making them compatible with calculations and data analysis.

Steps

1. Select the cell in your Excel worksheet that contains the TRUE or FALSE values you want to convert.
2. Navigate to the ribbon and click the formula bar to begin editing the cell's formula.
3. Enclose your logical formula in parentheses — for example, write it as (N3>5000).
4. Add two dash lines (--) directly after the equals sign so the formula reads =--(N3>5000), then press Enter to run the updated formula.
5. The TRUE and FALSE values in the selected cells will now display as 1 or 0.