Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
divide by zero error
getting the divide by zero error with this formula
=IF(F175=0,0,+F175/L155) F175=sum of cells equaling 4 L155=sum of cells equaling 0 any help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
divide by zero error
Try
=IF(AND(F175<0,L155<0),F175/L155,"") If this post helps click Yes --------------- Jacob Skaria "susancca" wrote: getting the divide by zero error with this formula =IF(F175=0,0,+F175/L155) F175=sum of cells equaling 4 L155=sum of cells equaling 0 any help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Divide by zero error | Excel Discussion (Misc queries) | |||
Divide by zero error | Excel Worksheet Functions | |||
Divide by Zero Error | Excel Worksheet Functions | |||
divide by 0 error jmp | New Users to Excel | |||
Divide by zero error | Excel Discussion (Misc queries) |