In C1 put
=A1/B1
Right-click on C1, Format Cells, Percentage.
Done.How to Calculate percentage in Microsoft Excel?
Let's assume these percentages were relating to the same amount, lets say $1000?
a = $50, b= $100, c= $150. Total = $300
Reducing the total commision by 10% would leave you with 300-30= $270. This equates to a 20% reduction in commision c ($30).
Therefore, you would have to reduce the commision rate c (which is 15%) by 20%. 20% of 15 is 3, so you would have to change c to 12%.
a 5%, b 10%, c 12%.
HERE IS THE OTHER EXAMPLE
So are you adjusting only Column C? And you want to know what the formula is?
If field C1 has 15% in it %26amp; you want 10% off of that, first find what 10% is %26amp; subtract.
So.....
C1: 15%
C2: =C1/100*10 (Will give you what 10% of the target number is)
C3: =SUM(C1-C2) (Will give the total percentage remaining).
Hope thats what you're trying to achieve.
I hope this will work for you
No comments:
Post a Comment