Hi Roger,
Thank you for your reply.
Your function still leaves the formula in the cell. What I need is the cell
to be empty , because an other formula works on some of the cells to
be empty (no formula) , as if the content of the cell has been deleted.
This is what I need AF
48 11 :- =
IF(ISERROR(S48*AE48/100),"",S48*AE48/100)
49 7 :- =
IF(ISERROR(S49*AE49/100),"",S48*AE49/100)
50 2 :- =
IF(ISERROR(S50*AE50/100),"",S48*AE50/100)
51 5 :- =
IF(ISERROR(S51*AE51/100),"",S48*AE51/100)
52
53 13 :- =
IF(ISERROR(S53*AE53/100),"",S48*AE53/100)
so on down to 4000 rows
I hope you can help

regards bill
--
bill gras


"Roger Govier" wrote:

Hi Bill

One way
=IF(ISERROR(S48*AE48/100),"",S48*AE48/100)

Regards

Roger Govier


bill gras wrote:
Hi All

Is there a worksheet function to do this ?

I have in column AF 48 a formula as follows:
S48*AE48/100 down to 4000 rows , in some rows this formula returns a #VALUE!
error . Is there a worksheet function that will return an empty cell (no
formula just empty cell) instead of a #VALUE! error ?

thanks
regards bill