Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formulas
=((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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formulas
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) "HARSH BAHAL" wrote in message ... =((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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formulas | New Users to Excel | |||
Conditional use of formulas | Excel Worksheet Functions | |||
Conditional Formulas | Excel Worksheet Functions | |||
How do I set up conditional formulas | Excel Worksheet Functions | |||
conditional formulas | Excel Worksheet Functions |