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