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.