I need to often be reminded of how to calculate a percentage. The context here is that I want a progress bar in one of my programs.
To determine what percent a number is of a total number:
copyraw
(Progress So Far / Total Progress Units) * 100 = % or (Net Amount / Gross Amount) * 100 = % eg. (12 steps / 30 steps) * 100 = 40% ie. 12 steps of 30 is 40% progress eg. ($8 / $10) * 100 = 80% ie. $8 of $10 is 80%
- (Progress So Far / Total Progress Units) * 100 = %
- or
- (Net Amount / Gross Amount) * 100 = %
- eg. (12 steps / 30 steps) * 100 = 40% ie. 12 steps of 30 is 40% progress
- eg. ($8 / $10) * 100 = 80% ie. $8 of $10 is 80%
To determine the percent (adjustment level) given the RRP and the price you're selling at:
copyraw
((Agreed Price - Usual Price) * 100) / Usual Price = % eg. ($10 - $8) * 100 / $8 = +25% ie. selling an $8 product at $10 is an increase of 25% eg. ($8 - $10) * 100 / $10 = -20% ie. selling a product at $8 when it usually costs $10 is a discount of 20% eg. ($7,562.50 - $8,281.80) * 100 / $8,281.80 = -8.69%
- ((Agreed Price - Usual Price) * 100) / Usual Price = %
- eg. ($10 - $8) * 100 / $8 = +25% ie. selling an $8 product at $10 is an increase of 25%
- eg. ($8 - $10) * 100 / $10 = -20% ie. selling a product at $8 when it usually costs $10 is a discount of 20%
- eg. ($7,562.50 - $8,281.80) * 100 / $8,281.80 = -8.69%
To determine the amount given the percentage and total amount:
copyraw
(Discount / 100) * Usual Price = Discounted Price eg. (20 / 100) * $80 = $16 ie. 20% of $80 is $16
- (Discount / 100) * Usual Price = Discounted Price
- eg. (20 / 100) * $80 = $16 ie. 20% of $80 is $16
To determine the percent given two percentages:
copyraw
((Percentage 1 / 100) * (Percentage 2 / 100)) * 100 = % eg. (50/100) * (40/100) = 0.5 x 0.4 = 0.2 * 100 = +20% ie. 50% of a 40% sale is 20%
- ((Percentage 1 / 100) * (Percentage 2 / 100)) * 100 = %
- eg. (50/100) * (40/100) = 0.5 x 0.4 = 0.2 * 100 = +20% ie. 50% of a 40% sale is 20%
Opportunities won vs opportunities lost:
copyraw
Percentage = Won / (Won + Lost) * 100 eg. 50% = 1 / (1 + 1) * 100
- Percentage = Won / (Won + Lost) * 100
- eg. 50% = 1 / (1 + 1) * 100
Opportunities won vs total:
copyraw
Total = Won + Lost + Other Percentage = Won / Total * 100 eg. 33.33% = 1 / (1 + 1 + 1) * 100
- Total = Won + Lost + Other
- Percentage = Won / Total * 100
- eg. 33.33% = 1 / (1 + 1 + 1) * 100
Markup Margin Percentage:
copyraw
( Sell - Cost ) / Cost * 100 = Markup Percent eg. ( 75 - 50 ) / 50 * 100 = 50%
- ( Sell - Cost ) / Cost * 100 = Markup Percent
- eg. ( 75 - 50 ) / 50 * 100 = 50%
Gross Margin Percentage:
copyraw
( Sell - Cost ) = Gross Profit ( Sell - Cost ) / Sell * 100 = Gross Margin Percent eg. ( 75 - 50 ) / 75 * 100 = 33.33%
- ( Sell - Cost ) = Gross Profit
- ( Sell - Cost ) / Sell * 100 = Gross Margin Percent
- eg. ( 75 - 50 ) / 75 * 100 = 33.33%
Margin Percentage With Discount Applied:
copyraw
((( Sell * Quantity ) - Discount ) - ( Cost * Quantity )) / (( Sell * Quantity ) - Discount ) * 100 eg. ( $100 * 1 ) - $20 - ( $50 * 1 ) / ( $100 * 1 ) - $20 * 100 = 37.5% eg. ( $120 * 2 ) - $40 - ( $50 * 1 ) / ( $120 * 2 ) - $40 * 100 = 50%
- ((( Sell * Quantity ) - Discount ) - ( Cost * Quantity )) / (( Sell * Quantity ) - Discount ) * 100
- eg. ( $100 * 1 ) - $20 - ( $50 * 1 ) / ( $100 * 1 ) - $20 * 100 = 37.5%
- eg. ( $120 * 2 ) - $40 - ( $50 * 1 ) / ( $120 * 2 ) - $40 * 100 = 50%
Category: eCommerce Systems :: Article: 268
