Error Messages

J

Jo Davis

Hi

Is there a way in my settings that i can get Excel to hide formula error
messages?

any help would be most appreciated.

Cheers
Jo
 
T

tony h

You have various option for handling errors.

Assuming that you are talking about worksheet functions returning error
values, rather than VBA code there are two options.

1. correct the result using something like
=if(iserror(formula),"",formula) this leaves the cell clear if the
formula returns an error.

2. cosmetically only you can use the conditional formatting (again
using the =iserror(A1) ) to set the font colour the same as the
background colour.

Just think carefully about future maintenance.
 
Top