Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=((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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |