Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dividing by zero
Hello,
I have this formula: I7=MAX(MIN(((I19-K19)/I19),0.15),-0.15), where I want the range to be from -0.15 to 0.15. However, when I19=0, I obviously get the message that I can't divide by zero. So, how would I change I7 so that when I19=0, I7 will equal -.15, BUT, when I19=0, AND K19=0, I7will equal 0. Thanks for you help, it is much appreciated, Regards, JV |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dividing zero by zero | Excel Worksheet Functions | |||
Dividing by Zero | Excel Discussion (Misc queries) | |||
Dividing name | Excel Worksheet Functions | |||
Dividing by zero | Excel Discussion (Misc queries) | |||
dividing a row | Excel Worksheet Functions |