Excel giving me wrong percentage answer

Ktyn111

New Member
Joined
Apr 11, 2018
Messages
7
I am trying to find % contribution. I know the answer to %18.29/$43.36 should equal 0.42181 which would be 42.18% but excel is giving me the answer 42.1877 rounding it to 42.19%. My answer needs to be 42.18%. How do I fix this?
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Hi,

Format cell, Percentage, change decimal places to what you want.
 
Upvote 0
Excel is giving me the wrong answer though, making the percentage round to a different number than 42.18%
 
Upvote 0
Also, I meant excel is giving me the answer .421877 rounding it to 42.18% when I need it to be 42.18%
 
Upvote 0
I'm not sure I know what you mean, I have the following:


Excel 2010
ABC
142.18%42.182%42.1817%
2Formatted to 2 decimal3 decimal4 decimal
Sheet2
Cell Formulas
RangeFormula
A1=18.29/43.36
B1=18.29/43.36
C1=18.29/43.36
 
Upvote 0
Where are these numbers (18.29, and 43.36) coming from? Another Formula?
 
Upvote 0
I am trying to divide $18.29/$43.36. The correct answer is 0.421817 which is 42.18%. But when I type the formula into excel (B70/B61) it is giving me 0.421877 which is making the percentage be 42.19%. Sorry if I explained it poorly.
 
Upvote 0
yes, from another formula.

Then you're actually getting the correct answer, because B70 is not 18.29, and B61 is not 43.36, you're only seeing 2 decimal places of B70 and B61.
 
Upvote 0
It sounds like a rounding error in B70 and/or B61. For instance, if B70 is 18.291 and B61 is 43.356, they will display as $18.29 and $43.36, yet when divided will give 0.421879
 
Upvote 0

Forum statistics

Threads
1,213,562
Messages
6,114,322
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top