HI

My formula in F3 is

=IF(B3="W",(SUM(C3/E3)*D3),C3*-1)

How can I amend this to suppress the DIV/0 error when I put "W" in B3?

I've seen various formulae which suggest they can do this , but can't
see how to merge them into the existing formula.


Grateful for any help.



Best Wishes