Conditional formulas

H

HARSH BAHAL

=((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
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top