Keep up to date with every new upload!

Join free & follow Chandoo.org Podcast - Become A
Share
  • 3 years ago
CP037: Error error on the wall, How do I fix you all? – Understanding & Fixing Excel Errors

CP037: Error error on the wall, How do I fix you all? – Understanding & Fixing Excel Errors

In the 37th session of Chandoo.org podcast, Let's debug 'em #VALUEs & #N/As.

What is in this session?

In this podcast,

Introduction to Excel formula errors
The easy kind: syntax errors
The triky ones: # ERRORs
Fixing errors - using IFERROR & ISERROR
Error checking & debug options
Using Errors deliberately - charts & data validation
A challenge for you - produce #NULL error
Conclusions

Comments