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
--
bill gras