Percentage Examples
Percentages are calculated for many things such as interest rates, income tax, profit margins, restaurant bills, and possession in football matches.
There are three main percentage calculations; each is shown in the document.
๐ฃ๐ฒ๐ฟ๐ฐ๐ฒ๐ป๐๐ฎ๐ด๐ฒ ๐ผ๐ณ ๐ง๐ผ๐๐ฎ๐น (๐ฃ๐ฎ๐ด๐ฒ ๐ญ)
๐๐๐๐ รท ๐๐๐๐๐ = %
The exam mark (Marks) is divided by the maximum possible (Total) to return the overall score as a percentage (%).
๐ฃ๐ฒ๐ฟ๐ฐ๐ฒ๐ป๐๐ฎ๐ด๐ฒ ๐๐ต๐ฎ๐ป๐ด๐ฒ ๐ผ๐ณ ๐ฉ๐ฎ๐น๐๐ฒ (๐ฃ๐ฎ๐ด๐ฒ ๐ฎ)
(๐๐๐ ๐๐๐๐๐ โ ๐๐๐ ๐๐๐๐๐) รท ๐๐๐ ๐๐๐๐๐ = % ๐๐๐๐๐๐
The previous month’s sales figure (Last Month) is subtracted from the current one (This Month), and then the result is divided by the former (Last Month) to give the percentage change (% Change).
๐ฉ๐ฎ๐น๐๐ฒ ๐๐ณ๐๐ฒ๐ฟ ๐ฃ๐ฒ๐ฟ๐ฐ๐ฒ๐ป๐๐ฎ๐ด๐ฒ ๐๐ต๐ฎ๐ป๐ด๐ฒ (๐ฃ๐ฎ๐ด๐ฒ ๐ฏ)
๐๐๐ ๐๐๐๐๐ ร (๐ท + % ๐๐๐๐๐๐) = ๐๐๐ ๐๐๐๐๐
The percentage (% Change) is added to 100%, and this is multiplied by the current price (Current Price) to create a new one (New Price).
๐ข๐๐ต๐ฒ๐ฟ ๐๐ป๐ณ๐ผ๐ฟ๐บ๐ฎ๐๐ถ๐ผ๐ป
Across the three examples, each percentage column actually returns a set of decimal numbers. However, as the columns use the Percentage cell format, they are outputted differently. If General was used, you’d have to multiply the calculation by 100 to achieve the same result, albeit without the percentage symbol.
