Incorrect total
 

I have used the sum command in Excel 2003 and it keeps calculating the wrong
total. any suggestions.

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.

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

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.

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

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