| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#DIV/O!
I get this #DIV/O! when I divide two cell that both total 0.
These cell will not always be used in the spreadsheet. Is there any way to show the total of these cell to be 0 when not used? -- Joe |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/O!
=IF(A2=0,0,A1/A2)
or in Excel 2007 =IFERROR(A1/A2,0) best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "painter50" wrote in message ... I get this #DIV/O! when I divide two cell that both total 0. These cell will not always be used in the spreadsheet. Is there any way to show the total of these cell to be 0 when not used? -- Joe |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/O!
Maybe something like this...
If you have something like this: =A1/B1, and B1 is an empty cell then try it like this: =IF(B1="",0,A1/B1) -- Biff Microsoft Excel MVP "painter50" wrote in message ... I get this #DIV/O! when I divide two cell that both total 0. These cell will not always be used in the spreadsheet. Is there any way to show the total of these cell to be 0 when not used? -- Joe |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/O!
Sun, 7 Mar 2010 18:13:01 -0800 from painter50 <painter50
@discussions.microsoft.com: I get this #DIV/O! when I divide two cell that both total 0. These cell will not always be used in the spreadsheet. Is there any way to show the total of these cell to be 0 when not used? =if(A2,A1/A2,0) -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/O!
This is the formulas I trying to fix
=(I5-P5)/Q5 I5=0 P5=0 Q5=0 I used =IF(ISERROR(I5-P5),"-",I5-P5) and it worked fine. The problem is when I try to divide the (I5-P5) Joe "painter50" wrote: I get this #DIV/O! when I divide two cell that both total 0. These cell will not always be used in the spreadsheet. Is there any way to show the total of these cell to be 0 when not used? -- Joe |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/O!
Try it like this...
=IF(Q5=0,"-",(I5-P5)/Q5) -- Biff Microsoft Excel MVP "painter50" wrote in message ... This is the formulas I trying to fix =(I5-P5)/Q5 I5=0 P5=0 Q5=0 I used =IF(ISERROR(I5-P5),"-",I5-P5) and it worked fine. The problem is when I try to divide the (I5-P5) Joe "painter50" wrote: I get this #DIV/O! when I divide two cell that both total 0. These cell will not always be used in the spreadsheet. Is there any way to show the total of these cell to be 0 when not used? -- Joe |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
