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 VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.