Excel Forum

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.