IF ERROR - A Cool New Excel Function

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
3,025
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jan 29, 2009

If you do a lot of calculations with denominators of 0 or Vlookups where there is not a match, then you probably have spreadsheets with Error messages. Tired of printing or publishing spreadsheets that display errors? Use Excel 2007's new function to hide those error messages. DIV/!0 and N/A# be gone!

Category:

Education

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (3)

Sign In or Sign Up now to post a comment!
  • =if(a1=0,0,if(b2=0,0,a1/b2 (Good for excel 2003), once you have typed this enough you get pretty quick at it

  • =if(a1=0,0,if(b2=0,0,a1/b1 (Good for excel 2003)

  • TYVM for this vid :D

Loading...

Alert icon
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