Excel Forum

Excel Magic Trick 367: Any Number Not Zero = TRUE

See that the IF function sees -1, 1, 10 and -1.23 as TRUE and 0 as FALSE. See this trick in an IF, SUMIF and SUM formula for Conditional summing. Adding with more than one criteria more than one condition.

Got a Question? Ask it Here in the Forum.