sums are wrong

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin Andrien - 18 Aug 2006 22:43 GMT

I have two cells that contain functions that return numbers. The cells are
formatted as numbers, and display as numbers. When I try to sum these two
cells the answer is wrong. The SUM cell is also formatted as a number.
Embarrassed to say I've been programming for 40 years and can't get by this!

Reply to this Message

Marcelo - 18 Aug 2006 22:52 GMT

Hi what means Wrong?

another result? #value?

Signature

regards from Brazil
Thanks in advance for your feedback.
Marcelo

> I have two cells that contain functions that return numbers. The cells are
> formatted as numbers, and display as numbers. When I try to sum these two
> cells the answer is wrong. The SUM cell is also formatted as a number.
> Embarrassed to say I've been programming for 40 years and can't get by this!

Reply to this Message

Desert Piranha - 19 Aug 2006 01:17 GMT

Kevin Andrien Wrote:

> I have two cells that contain functions that return numbers. The cell
> are
[quoted text clipped - 4 lines]
> Embarrassed to say I've been programming for 40 years and can't get b
> this!Hi Kevin,

Without knowing any details, is Excel "rounding" the data that goe
into the SUM cell?

--
Desert Piranh

Reply to this Message

Ron Rosenfeld - 19 Aug 2006 01:37 GMT

>I have two cells that contain functions that return numbers. The cells are
>formatted as numbers, and display as numbers. When I try to sum these two
>cells the answer is wrong. The SUM cell is also formatted as a number.
>Embarrassed to say I've been programming for 40 years and can't get by this!

SUM will add the values that are actually in the cell, not necessarily what you
see displayed.

1.44
1.24
1.34

Formatted to number with one decimal place:

1.4
1.2
1.3

But SUM will --> 4.0 (4.02 rounded to one decimal) and not 3.9

--ron

Reply to this Message