Excel Error Log File

Forums: Computers
Email this Topic • Print this Page

Can anyone tell me where the Excel error log file resides and what it is called.

Thanks

Topic Stats
Top Replies
Link to this Topic

Type: Discussion • Score: 1 • Views: 439 • Replies: 1

No top replies

I don't know if there's an error log, per se. There is an error command (spot the error). It's error.type - try =error.type(cel value) , where cel value is A4 or whatever.

Code:

If error_val is ERROR.TYPE returns 

#NULL!                       1 

#DIV/0!                      2 

#VALUE!                      3 

#REF!                        4 

#NAME?                       5 

#NUM!                        6 

#N/A                         7 

Anything else              #N/A

0 Replies

Excel Error Log File

Related Topics

Quick Links

My Account

able2know