Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Excel Magic Trick 367: Any Number Not Zero = TRUE

Loading...

Sign in or sign up now!
2,256
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Aug 13, 2009

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.

  • likes, 0 dislikes

Link to this comment:

Share to:

All Comments (0)

Sign In or Sign Up now to post a comment!
Loading...

0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more