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.