xl2003
I am getting the above in cells that are either blank or refering to a cell
that has alpahbetical data in it rather than numbers
My spreadsheet contains a table a data and then tables of formulas that work
the data. It is the data of formulas that are the problem
What I want is to have blank cells

I am using =IF(ISERROR(SUM((G20-F20)/F20)),"",SUM((G20-F20)/F20))
successfully in the empty cells that are part of the data table. But get
#N/A in the following =VLOOKUP(CD18, $Q$7:$R$26, 2,FALSE) when the
corresponding data cell has "scr" in it instead of a number. I need to leave
"Scr" in


I am also getting #Value! when using =SUM(CW17-CW16).

I have tried using =If(Iserror..... but am not getting anywhere.

Any help would be greatly apprciaed.
Ta,
Martin