|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 12th, 2009, 02:35 PM
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
November 12th, 2009, 02:41 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
divide by zero error
Try
=IF(AND(F1750,L1550),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?
|
|
#3
November 12th, 2009, 03:41 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
divide by zero error
Firstly you don't need the + before F175/H155
Secondly you don't need to test for F175 being zero, because if F175 is zero and you divide it by anything non-zero you'll get zero anyway. What you need to test for to avoid a #DIV/0! error is L155 being zero. =IF(F155=0,"",F175/L155) -- David Biddulph "susancca" wrote in message ... 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?
|
|
#4
November 12th, 2009, 03:57 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
divide by zero error
"L155=sum of cells equaling 0"...?
Should that be "count of cells equalling 0"? =IF(ISERROR(IF(F175=0,0,F175/L155)),"",IF(F175=0,0,F175/L155)) Vaya con Dios, Chuck, CABGx3 "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?
|
|
#5
November 12th, 2009, 04:37 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
divide by zero error
"susancca" wrote:
getting the divide by zero error with this formula =IF(F175=0,0,+F175/L155) It is sufficient to write: =IF(L155=0, 0, F175/L155) F175/L155 results in zero naturally when F175 is zero or empty.
|
|
#6
November 12th, 2009, 09:04 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
divide by zero error
Thank you very much! this helped tremendously and I can fix my managers
spreadsheet  ! "David Biddulph" wrote: Firstly you don't need the + before F175/H155 Secondly you don't need to test for F175 being zero, because if F175 is zero and you divide it by anything non-zero you'll get zero anyway. What you need to test for to avoid a #DIV/0! error is L155 being zero. =IF(F155=0,"",F175/L155) -- David Biddulph "susancca" wrote in message ... 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? .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
