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?

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?

And on top of Roger's comments, you can round the result using the ROUND()
function & thereby make it EXACTLY 104.87%

"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?

Thank you. That makes sense. But, do you know of anyway to make sure it calcs
on the 104.87%?

"Roger Govier" wrote:

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?

Oh, thank you! You guys are lifesavers!

"Duke Carey" wrote:

And on top of Roger's comments, you can round the result using the ROUND()
function & thereby make it EXACTLY 104.87%

"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?