=IF(ISERROR(D1*E1/F1)=TRUE,"","D1*E1/F1")
=IF(ISERROR(D1*E1/F1)=TRUE,"",sum(D1*E1/F1))
may i just ask,
do you add the '=TRUE' to the iserror so it is more readable?
Sam
Hi Guy's,
I am not as experienced as most of you with Excel just self tought.