View Single Post
  #1   Report Post  
vlatham
 
Posts: n/a
Default Median result used in formula gives incorrect result

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?