Excel variation confusion

R

ram1000

I have an excel file with some simple math:
=SUM(D10*D8)

The answer comes out
$126,017.90


This is the wrong answer.

D10 is a value figured from another cell x*94%
x=67.30 and is a varibale choice of two, the result is 63.26 w/ tw
decimals and is formated for currency.
D8 = 1992
1992*63.26 = $126,013.92
If I have a cell multiply these two numbers from a couple other cell
it comes out right????

Can't seem to find the problem, can you
 
C

Christopher Tolo

The answer is correct. The problem is that just because you only display two digits, there really is a third from the result of 67.3*.94=63.262. This number times 1992 equals 126,017.9

I think you will need to round the number if you only want to mulitple it by the two digits instead of the three.
 
Top