| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 produces error in calculation.
I use Excel to do Sudoku puzzles. In the process of doing this I have
produced an Excel spreadsheet that calculates incorrectly. I cannot post the file here but I will email it if anyone is interested. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 produces error in calculation.
Try to give a simple example.
best wishes -- Bernard Liengme www.stfx.ca/people/bliengme Microsoft Excel MVP remove CAPS in email address "Wes at CCC" wrote in message ... I use Excel to do Sudoku puzzles. In the process of doing this I have produced an Excel spreadsheet that calculates incorrectly. I cannot post the file here but I will email it if anyone is interested. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 produces error in calculation.
Can't you describe your error and the circumstances that give rise to
it, along with a copy of the formula that you think is calculating incorrectly? Pete On Nov 16, 7:56 pm, Wes at CCC wrote: I use Excel to do Sudoku puzzles. In the process of doing this I have produced an Excel spreadsheet that calculates incorrectly. I cannot post the file here but I will email it if anyone is interested. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 produces error in calculation.
It occurs when merging cells. If there are values in the various cells being
merged Excel (2002 with SP3) does not completely clear the values out of the cells. There some residual values are included in sums and counts. I have this on several examples. But, sometimes I cannot reproduce the error. "Bernard Liengme" wrote: Try to give a simple example. best wishes -- Bernard Liengme www.stfx.ca/people/bliengme Microsoft Excel MVP remove CAPS in email address "Wes at CCC" wrote in message ... I use Excel to do Sudoku puzzles. In the process of doing this I have produced an Excel spreadsheet that calculates incorrectly. I cannot post the file here but I will email it if anyone is interested. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 produces error in calculation.
There are many warnings on these newsgroups not to merge cells.
Pete On Nov 16, 8:31 pm, Wes at CCC wrote: It occurs when merging cells. If there are values in the various cells being merged Excel (2002 with SP3) does not completely clear the values out of the cells. There some residual values are included in sums and counts. I have this on several examples. But, sometimes I cannot reproduce the error. "Bernard Liengme" wrote: Try to give a simple example. best wishes -- Bernard Liengme www.stfx.ca/people/bliengme Microsoft Excel MVP remove CAPS in email address "Wes at CCC" wrote in message ... I use Excel to do Sudoku puzzles. In the process of doing this I have produced an Excel spreadsheet that calculates incorrectly. I cannot post the file here but I will email it if anyone is interested.- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refresh produces #N/A error | Links and Linking in Excel | |||
| Refresh produces #N?A error | Excel Discussion (Misc queries) | |||
| time v cost calculation in Excel 2002 (XP) | Excel Discussion (Misc queries) | |||
| Adding more than 3 cells (2003)produces "0" but no error message | Excel Worksheet Functions | |||
| Excel 2002 error | Excel Discussion (Misc queries) | |||
Linear Mode
