Excel Forum
Similar Content
Convert Numbers into True and False in Excel
Tutorial: How to convert numbers into the TRUE and FALSE Boolean values in Excel. This is very impor...
Count Cells Containing TRUE or FALSE in Excel
Tutorial: Count the number of cells that contain TRUE, FALSE, or one of the two. This lets you count...
NOT Function - Change False to True and True to False in Excel
Tutorial: Change True to False and False to True with this simple function in Excel. To do this, we ...

Excel Magic Trick 314: Convert TRUE & FALSE to 1 and 0

See 4 methods for converting TRUE and FALSE to 1 and 0 (zero) using double negative, multiply by one, add zero, and divide by one: --TRUE, TRUE*1, TRUE+0, TRUE/1. See the SUMPRODUCT function and learn about the Order Of Precedents that Excel follows when evaluating formulas.

Got a Question? Ask it Here in the Forum.