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

‍

‍

It is very easy to convert the true and false values to 1 and 0 in MS Excel. Here’s a short guide on how to do it:

‍

1. Inside your Microsoft Excel worksheet, select the cell that contains the true and false values you wish to edit.
2. After that, head over to the ribbon section and click the formula bar.
3. Enclose the formula in parentheses as shown in the example: (N3>5000).
4. Subsequently, add two dash lines (-) next to the equals sign. Follow this format: '=--(N3>5000)'. Once done, press the enter key to run the newly revised formula.
5. After completing these steps, the true and false values from the selected cells will be converted to 1 or 0.