Title:
Excel Magic Trick 314: Convert TRUE and FALSE to 1 and 0
Video:
Description: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.
Published:
02/May/2009
Excel Magic Trick 314: Convert TRUE and FALSE to 1 and 0
Video:
Description: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.
Published:
02/May/2009
No comments:
Post a Comment