|
| 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
October 15th, 2008, 04:30 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#DIV/0! Question
I am migrating to Office 2007 and I am receiving #DIV/0!
in all of my cells on my workbooks. Can anyone help me find a soloction to this problem. I am able to enter numbers but the results are the same #DIV/0! thank you 
|
|
#2
October 15th, 2008, 04:44 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/0! Question
The formula(s) would be good to know.
-- John C "TKM" wrote: I am migrating to Office 2007 and I am receiving #DIV/0! in all of my cells on my workbooks. Can anyone help me find a soloction to this problem. I am able to enter numbers but the results are the same #DIV/0! thank you
|
|
#3
October 15th, 2008, 05:06 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/0! Question
Hi,
"all of my cells"? cells that are empty, cells that contain text, cells with single numbers and formulas, all return DIV/0? This error usually only occurs with calculations, (formulas or functions). If that is what you mean, do you really mean all - is the formula =sum(a1:a10) returning DIV/0 when A1:A10 are blank? If it really is - some formulas, we need to know the formula and maybe some sample data, that is used by that formula. -- Thanks, Shane Devenshire "TKM" wrote: I am migrating to Office 2007 and I am receiving #DIV/0! in all of my cells on my workbooks. Can anyone help me find a soloction to this problem. I am able to enter numbers but the results are the same #DIV/0! thank you
|
|
#4
October 15th, 2008, 05:36 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/0! Question
Yes that would help sorry. Here are some basics.
=E2/E5 =Sheet1!A5 =Sheet1!AH13 =1-(O3*3+O6*3)/(O2-O5) "ShaneDevenshire" wrote: Hi, "all of my cells"? cells that are empty, cells that contain text, cells with single numbers and formulas, all return DIV/0? This error usually only occurs with calculations, (formulas or functions). If that is what you mean, do you really mean all - is the formula =sum(a1:a10) returning DIV/0 when A1:A10 are blank? If it really is - some formulas, we need to know the formula and maybe some sample data, that is used by that formula. -- Thanks, Shane Devenshire "TKM" wrote: I am migrating to Office 2007 and I am receiving #DIV/0! in all of my cells on my workbooks. Can anyone help me find a soloction to this problem. I am able to enter numbers but the results are the same #DIV/0! thank you
|
|
#5
October 15th, 2008, 06:59 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/0! Question
=E2/E5 will return #DIV/0! if E5 is zero or empty, so you need to have a
look to see what is in E5. =E2/E5 will also return #DIV/0! if E2 contains #DIV/0!, so you may also need to have a look to see what is in E2. =Sheet1!A5 will return #DIV/0! if Sheet1!A5 contains #DIV/0!, so you need to have a look to see what is in Sheet1!A5. =Sheet1!AH13 will return #DIV/0! if Sheet1!AH13 contains #DIV/0!, so you need to have a look to see what is in Sheet1!AH13. =1-(O3*3+O6*3)/(O2-O5) will return #DIV/0! if O2-O5 is zero or those cells are empty, so you need to have a look at what is in O2 and O5. =1-(O3*3+O6*3)/(O2-O5) will also return #DIV/0! if either O3 or O6 contain #DIV/0!, so you may also need to have a look at what is in O3 and O6. -- David Biddulph "TKM" wrote in message ... Yes that would help sorry. Here are some basics. =E2/E5 =Sheet1!A5 =Sheet1!AH13 =1-(O3*3+O6*3)/(O2-O5) "ShaneDevenshire" wrote: Hi, "all of my cells"? cells that are empty, cells that contain text, cells with single numbers and formulas, all return DIV/0? This error usually only occurs with calculations, (formulas or functions). If that is what you mean, do you really mean all - is the formula =sum(a1:a10) returning DIV/0 when A1:A10 are blank? If it really is - some formulas, we need to know the formula and maybe some sample data, that is used by that formula. -- Thanks, Shane Devenshire "TKM" wrote: I am migrating to Office 2007 and I am receiving #DIV/0! in all of my cells on my workbooks. Can anyone help me find a soloction to this problem. I am able to enter numbers but the results are the same #DIV/0! thank you
|
|
#6
October 16th, 2008, 06:09 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/0! Question
Thank you for your hdlp! I was courious that =($C$124-C126)/$C$124 and all
other formuls had the same type of error when the sheet was opened. No values were placed into the cells it only shows these when the application is opened. Are you saying something must be in the cells before those errors dissappear? thanks for your help "David Biddulph" wrote: =E2/E5 will return #DIV/0! if E5 is zero or empty, so you need to have a look to see what is in E5. =E2/E5 will also return #DIV/0! if E2 contains #DIV/0!, so you may also need to have a look to see what is in E2. =Sheet1!A5 will return #DIV/0! if Sheet1!A5 contains #DIV/0!, so you need to have a look to see what is in Sheet1!A5. =Sheet1!AH13 will return #DIV/0! if Sheet1!AH13 contains #DIV/0!, so you need to have a look to see what is in Sheet1!AH13. =1-(O3*3+O6*3)/(O2-O5) will return #DIV/0! if O2-O5 is zero or those cells are empty, so you need to have a look at what is in O2 and O5. =1-(O3*3+O6*3)/(O2-O5) will also return #DIV/0! if either O3 or O6 contain #DIV/0!, so you may also need to have a look at what is in O3 and O6. -- David Biddulph "TKM" wrote in message ... Yes that would help sorry. Here are some basics. =E2/E5 =Sheet1!A5 =Sheet1!AH13 =1-(O3*3+O6*3)/(O2-O5) "ShaneDevenshire" wrote: Hi, "all of my cells"? cells that are empty, cells that contain text, cells with single numbers and formulas, all return DIV/0? This error usually only occurs with calculations, (formulas or functions). If that is what you mean, do you really mean all - is the formula =sum(a1:a10) returning DIV/0 when A1:A10 are blank? If it really is - some formulas, we need to know the formula and maybe some sample data, that is used by that formula. -- Thanks, Shane Devenshire "TKM" wrote: I am migrating to Office 2007 and I am receiving #DIV/0! in all of my cells on my workbooks. Can anyone help me find a soloction to this problem. I am able to enter numbers but the results are the same #DIV/0! thank you
|
|
#7
October 19th, 2008, 01:20 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/0! Question
Hi,
So its not really all cells, just ones containing formulas. If one formula returns a DIV/0 error any other formulas which refer to it will also return the error. Errors propogate in Excel. -- Thanks, Shane Devenshire "TKM" wrote: Yes that would help sorry. Here are some basics. =E2/E5 =Sheet1!A5 =Sheet1!AH13 =1-(O3*3+O6*3)/(O2-O5) "ShaneDevenshire" wrote: Hi, "all of my cells"? cells that are empty, cells that contain text, cells with single numbers and formulas, all return DIV/0? This error usually only occurs with calculations, (formulas or functions). If that is what you mean, do you really mean all - is the formula =sum(a1:a10) returning DIV/0 when A1:A10 are blank? If it really is - some formulas, we need to know the formula and maybe some sample data, that is used by that formula. -- Thanks, Shane Devenshire "TKM" wrote: I am migrating to Office 2007 and I am receiving #DIV/0! in all of my cells on my workbooks. Can anyone help me find a soloction to this problem. I am able to enter numbers but the results are the same #DIV/0! thank you
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
