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 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.