| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to .. | Excel Discussion (Misc queries) | |||
| excel | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Copy Paste of Formula Produces Incorrect Result | Excel Discussion (Misc queries) | |||
| How can i change this VBA project According to Indian Numeric | Excel Discussion (Misc queries) | |||
Threaded Mode
