Weird Excel Math Issue
Ok, so I have an equation in J14, which is
=(A4+A10A2A8)/2
A4 is 15.15, A2 is 15.00 A10 is 25.47, A8 is 25.00
These 4 values are set as currency, 2 decimal points.
The resulting answer is 0.31. As it should be.
But then I want to take J14*1704 which should be 528.24.
However Excel is giving me 522.92
If I remove the equation from J14 and manually enter 0.31 excel gives me the proper answer of 528.24. Put the equation back in, and even though the cell still says 0.31, it gives me 522.92.
Any guesses as to what is going on?
Excel 2007 BTW
