The code is =IF(ISERROR(C21*6),"",(C21*6)). The cells have to be in number
format. The initial cells with this function left the cell blank even with
the format of the cells being number "General Format) I just added some rows
and dragged the formula down. Acutally one cell showed no zero and then the
cells following showed 0's

Thanks again for your help.


"db" wrote:

Can you provide an example of the code which is displaying 0?
--
Regards,
db


"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