4 ways to calculate percentages in Excel
Whether it's calculating interest rates, income tax, profit margins, or restaurant bills, you haven't got to look far for examples of where percentages are used.
Let's look at four methods of calculating percentages in Excel. It's worth noting that these examples all assume the use of the Percentage number format, removing the need to multiply by 100.
𝗣𝗲𝗿𝗰𝗲𝗻𝘁𝗮𝗴𝗲 𝗼𝗳 𝘁𝗼𝘁𝗮𝗹
𝚙𝚊𝚛𝚝 ÷ 𝚝𝚘𝚝𝚊𝚕 = %
E.g. 58 ÷ 100 = 58%
58 marks out of 100 is 58%
𝗣𝗲𝗿𝗰𝗲𝗻𝘁𝗮𝗴𝗲 𝗰𝗵𝗮𝗻𝗴𝗲 𝗼𝗳 𝘃𝗮𝗹𝘂𝗲
(𝚗𝚎𝚠 𝚟𝚊𝚕𝚞𝚎 ÷ 𝚘𝚕𝚍 𝚟𝚊𝚕𝚞𝚎) − 𝟷 = % 𝚌𝚑𝚊𝚗𝚐𝚎
E.g. (£1,125 ÷ £1,000) − 1 = 25%
£1,000 to £1,125 is a 25% increase
𝗣𝗲𝗿𝗰𝗲𝗻𝘁𝗮𝗴𝗲 𝗰𝗵𝗮𝗻𝗴𝗲 𝗼𝗳 𝗽𝗲𝗿𝗰𝗲𝗻𝘁𝗮𝗴𝗲
(𝚗𝚎𝚠 % – 𝚘𝚕𝚍 %) ÷ 𝚘𝚕𝚍 % = % 𝚌𝚑𝚊𝚗𝚐𝚎
E.g. (10% − 5%) ÷ 5% = 100%
5% to 10% is a 100% increase
𝗩𝗮𝗹𝘂𝗲 𝗮𝗳𝘁𝗲𝗿 𝗽𝗲𝗿𝗰𝗲𝗻𝘁𝗮𝗴𝗲 𝗰𝗵𝗮𝗻𝗴𝗲
𝚘𝚕𝚍 𝚟𝚊𝚕𝚞𝚎 × (𝟷 + % 𝚌𝚑𝚊𝚗𝚐𝚎) = 𝚗𝚎𝚠 𝚟𝚊𝚕𝚞𝚎
E.g. £50 × (1 + 10%) = £55
10% added to £50 is £55
#exceleration #excel #globalexcelsummit
---
The Global Excel Summit is the world's largest gathering of Microsoft Excel users and experts.
Find us on:
🌐 Website: https://globalexcelsummit.com
👔 LinkedIn: / global-excel-summit
🆇 X: https://x.com/ExcelSummit
🤳 TikTok: / globalexcelsummit
📸 Instagram: / globalexcelsummit
🟦 Facebook: / globalexcelsummit
🧵 Threads: https://www.threads.net/@globalexcels...