sums are wrong

K

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

Marcelo

Hi what means Wrong?

another result? #value?


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



"Kevin Andrien" escreveu:
 
D

Desert Piranha

Kevin said:
I have two cells that contain functions that return numbers. The cell
are
formatted as numbers, and display as numbers. When I try to sum thes
two
cells the answer is wrong. The SUM cell is also formatted as
number.
Embarrassed to say I've been programming for 40 years and can't get b
this!Hi Kevin,
Click to expand...

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

Ron Rosenfeld

On Fri, 18 Aug 2006 14:43:02 -0700, Kevin Andrien <Kevin
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!
Click to expand...

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
 
Top