Hi

Try increasing the number of decimals on your cell containing 104.87% and I
am sure you will see that it is actually 104.86686175072500% shown in a
rounded display to 2 decimal places.

Excel is using the more accurate figure when making the calculation and
giving the correct result.


Regards

Roger Govier


vlatham wrote:
I have a cell that contains the Median of 5 cells w/percentages in them.
Then I have a cell that adds the Median result with 100%. (Median result
4.87%, formula result 104.87%). Then I'm trying to multiply a cell that
contains 377,615 by the cell that contains the result 104.87%. My result
should be 396,005, but it's not. It keeps coming up with 395,993. I've
tried the formula every way I know how and it doesn't come up with the
correct result. Can someone help me, please?