View Single Post
  #5   Report Post  
vlatham
 
Posts: n/a
Default

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?