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.