sums are wrong

[Kevin Andrien]

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!

[Marcelo]

Hi what means Wrong?

another result? #value?


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Kevin Andrien" escreveu:

> 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!

[Desert Piranha]

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!

Hi Kevin,

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

[Ron Rosenfeld]

On Fri, 18 Aug 2006 14:43:02 -0700, Kevin Andrien <Kevin
[email protected]> wrote:

>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