Conditional formulas

[Guest]

=((J8/I8%)*(J8-I8)*2+(L8/K8%)*(L8-K8)+(N8/M8%)*(N8-M8))*15/1000
The above is a formula which I have inserted in a cell. My problem is that
if any one of the cell has a value zero then the returned value is#DIV.
Particularly I want to set the formula for the cell N8 (which is again linked
to three different cell), i.e. if N8=0 than also it should return a value.
Kindly help

 

[Bob Phillips]

This only fails for me if I8, K8 or M8 is zero, and you can test this

=IF(OR(I8=0,I8="",K8=0,K8="",M8=0,M8=""),"",((J8/I8%)*(J8-I8)*2+(L8/K8%)*(L8-K8)+(N8/M8%)*(N8-M8))*15/1000)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)