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