| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Incorrect total
I have used the sum command in Excel 2003 and it keeps calculating the wrong
total. any suggestions. |
|
#2
|
|||
|
|||
|
Hi
could you give an example. But maybe it is just a rounding issue. See: http://www.cpearson.com/excel/rounding.htm -- Regards Frank Kabel Frankfurt, Germany Karen wrote: I have used the sum command in Excel 2003 and it keeps calculating the wrong total. any suggestions. |
|
#3
|
|||
|
|||
|
Nope not a rounding issue..... a blonde issue. I have just discovered I had a
hidden cell in the equation. Thanks for responding. Karen "Frank Kabel" wrote: Hi could you give an example. But maybe it is just a rounding issue. See: http://www.cpearson.com/excel/rounding.htm -- Regards Frank Kabel Frankfurt, Germany Karen wrote: I have used the sum command in Excel 2003 and it keeps calculating the wrong total. any suggestions. |
|
#4
|
|||
|
|||
|
On Thu, 25 Nov 2004 13:47:03 -0800, "Karen"
wrote: I have used the sum command in Excel 2003 and it keeps calculating the wrong total. any suggestions. Without any other information, the only suggestion I can make is that either your assumptions regarding addition in Excel are incorrect, or the numbers you think you are adding are not, in fact, the numbers that Excel is actually adding. --ron |
|
#5
|
|||
|
|||
|
Please see my response to "Frank". Thanks for your response.
Karen "Ron Rosenfeld" wrote: On Thu, 25 Nov 2004 13:47:03 -0800, "Karen" wrote: I have used the sum command in Excel 2003 and it keeps calculating the wrong total. any suggestions. Without any other information, the only suggestion I can make is that either your assumptions regarding addition in Excel are incorrect, or the numbers you think you are adding are not, in fact, the numbers that Excel is actually adding. --ron |
|
#6
|
|||
|
|||
|
On Thu, 25 Nov 2004 17:57:02 -0800, "Karen"
wrote: Please see my response to "Frank". Thanks for your response. Karen Glad you figured it out. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| keep a running total of my formula results after each (F9) | Excel Discussion (Misc queries) | |||
| how to add time total in msg box | Excel Discussion (Misc queries) | |||
| ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
| Create a total based on multiple conditions is not giving correct. | Excel Worksheet Functions | |||
Hybrid Mode
