Excel Forum

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.