Monday, January 23, 2012

How to Calculate percentage in Microsoft Excel?

If i was doing a grade book, and had the Points earned in A1 and points possible in B1, could i put the percent in C1?How to Calculate percentage in Microsoft Excel?
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
  • google translations
  • college books
  • No comments:

    Post a Comment