Formula calculating to the 3rd decimal
Hi,
First, you didn't tell us what was in A1 and A2 but even so your math is
incorrect
sum (A3*.05) is $125.53 is not correct, instead it is
125.5315
=sum(A3*.07) is $ 175.74 is not correct either it is
175.7441
The sum of these first 3 numbers is 2811.9056 which rounds up to 2811.91
=================
Second, the formulas you are using should not be written as they are,
although it has no effect on the results, they should be
=A3*0.05
=A3*0.07
=SUM(A3:A5)
===============
Third, if you really want to ignore the values beyond the second decimal
place then
=TRUNC(A3*0.05,2)
=TRUNC(A3*0.07,2)
=SUM(A3:A5)
If you only want the final number treated this way then:
=SUMPRODUCT(TRUNC(A3:A5,2))
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"Shayla2008" wrote:
I am using simple addition & multiplication formulas and the sum appears to
be calculating to the 3rd decimal which is making my totals unacceptable. My
formatting in the cells are for 2 decimal places. How can I ensure the
formula is also calculating to only the 2nd decimal place?
|