Excel is rounding up hidden numbers in my formula

W

wtoddb

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

I have created a set of dollar number from calculations. they are as follows.
$9.19 actual $9.194797688
$9.19 actual $9.194797688
$9.19 actual $9.194797688
$9.19 actual $9.194797688
$6.41 actual $6.413757225
Excel totals these $43.19

Why is it looking at the whole number and not just what I ask it for when I specify 2 digits$ and how can I fix this?
 
C

Carl Witthoft

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

I have created a set of dollar number from calculations. they are as follows.
$9.19 actual $9.194797688
$9.19 actual $9.194797688
$9.19 actual $9.194797688
$9.19 actual $9.194797688
$6.41 actual $6.413757225
Excel totals these $43.19

Why is it looking at the whole number and not just what I ask it for when I
specify 2 digits$ and how can I fix this?
Click to expand...

This can be tricky the first time around: if you are specifying the
number of digits to show in the cell, that is purely cosmetic. Excel
processes the "real" numbers that were entered or calculated.

There are two ways around this. One, highly NOT recommended, is to
select the Preference (I forget where it shows up) to set the numbers in
cells to be exactly as the number of digits displayed.

Much better is to apply the ROUND() function to get just the part you
want.
In your case, something like

=SUM(ROUND(A1:A6,2)) , entered as an array formula, should work.
 
Top