Main Profile

At A Glance

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.
Length: 06:07

Contact

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

Want more info about Excel Magic Trick 314: Convert TRUE & FALSE to 1 and 0? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question