Excel Forum
Similar Content
Capitalize First Letter of Every Word in a Cell - PROPER Function
Tutorial: In Excel you can use a function to capitalize the first letter of every word in a cell.  ...
Make All Text Upper Case or Lower Case in Excel
Tutorial: How to quickly change all text to upper case or lower case in Excel.  This allows you to ...
Quickly Convert Formulas into Their Output Values in Excel
Tutorial: This tutorial teaches you how to convert a formula or function into its displayed output ...
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 653: Boolean Math Bonus Instead of IF Function


Replace your IF function with a shorter Boolean Math formula! TRUE = 1, FALSE = 0, TRUE*2000 = 2000 and FASLE*2000 = 0. See how to create Logical formulas. See how to create Boolean Math formulas.





Got a Question? Ask it Here in the Forum.