Thread: ISERROR
View Single Post
  #3   Report Post  
rahrah3a
 
Posts: n/a
Default

maybe it's an issue with formating??
if the cells with the iserror function are formated as number, it will show
a 0, you will
need to convert the Data format to text to show a blank

"Dee" wrote:

I entered the ISError in my spreadsheet in order to hide the error messages
in my cells. It works great. However, I needed to add more rows and I dragged
the formula down into the cells in the new rows and I get a 0 in these cells.

Could someone explain why this is happening, I don't have a 0 in the cells I
entered the ISERROR into in the first place.

Thanks very much for any help.

Best regards

Dee