PDA

View Full Version : Solved: Excel Error Lists...?



asingh
12-18-2006, 12:04 AM
Hi,

Could anyone guide me to a link...or create a list of Excel Formula Generated Errors..with their reasons....till date I have:

1. #NA : Lookup value not found in array
2. #REF : Relative/Absolute Refernce broken or not found.
3. #DIV : A Division Error.
4. #NAME : Operator not recognized in formula. Example "SUMI"
5. #VALUE: Wrong Arguements passed to a formula.
6. #####: Column not wide enough or Time/Date with Negative Vector.

Are there more..I am sure there are....?

thanks and regards,
Asingh

Bob Phillips
12-18-2006, 02:30 AM
Look at ERROR.type in help. You have more or less got them.

###### is not a formula generated error, it is a presentational error, Excel cannot show the result, either the column is not wide enough (easily fixed), or negative time (fix the formula or use 1904 date system).

asingh
12-18-2006, 03:17 AM
Sure..thanks....marking this as solved...!