WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Calculate Percentage in Excel Formula

Calculate Percentage in Excel Formula

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

How to Calculate Percentage in Excel using Formula?

Percentages are always calculated on per hundred bases. That means per hundred what is the proportion. We need two kinds of numbers one is the numerator, and another one is the denominator. We always divided the numerator by the denominator and multiplied the result by 100 to get the percentage value.

For example: Assume you were on vacation for 15 days, and you have spent ten days in your hometown and the remaining five days in the USA. What is the percentage of days you have spent in the USA?

Here the total number of vacations is 15 days. It is split into two parts one is 10 days in hometown and 5 days in the USA.

  • The excel formula for percentage is Portion Days / Total Days * 100.
  • Percentage of Days spent in USA = 5 / 15 * 100 = 33.33%
  • Percentage of Days spent in Home Town = 10 / 15 * 100 = 66.66%

Examples

You can download this Formula for Percentage Excel Template here – Formula for Percentage Excel Template

Example #1

I have a given task to calculate the formula for percentage in excel of students based on the marks obtained in the year-end exams.

They had given me total marks in each subject. Each subject carries a maximum of 100 marks.

Excel Formula for Percentage example 1

  • Step 1: To get the percentage of each student, I need to calculate the total marks obtained by them among 6 subjects. Let me calculate total marks by adding all the 6 subjects together for each student.

Excel Formula for Percentage example 1-1

Now I got a total of each student by adding all the 6 subjects together.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Excel Formula for Percentage example 1-2

  • Step 2: Now, we have the total marks column, i.e., numerator value. Maximum marks from 6 subjects is 600 i.e. 100 * 6 = 600 (denominator). Let me divide the marks obtained by each student by 600. i.e., Marks Scored / Total Marks *100

Excel Formula for Percentage example 1-4

  • Step 3: Now, we got the numbers. To arrive at the percentage values, we need to change the formatting of the cell. Select all the percentage cells and press Ctrl + Shift + %, or you can change the format under Home and Number then %

Excel Formula for Percentage example 1-5

Example #2

All most all the corporate companies try to find out the efficiency percentage of their employees. Below is the individual sales employee sales report against their set targets. I need to calculate the efficiency level of each employee based on their target.

Excel Formula for Percentage example 2

Now we all know how to calculate excel formula for a percentage. Here the formula is Sales / Target.

Excel Formula for Percentage example 2-1

We go the efficiency levels, but in the end, we got two-division errors in excel, i.e., #DIV/0!.

Excel Formula for Percentage example 2-2

We can eliminate this error by just tweaking our existing formula with the IFERROR formula in excel. IFERROR formula is crucial here. If the calculation of Sales / Target returns.

example 2-3

We get the result as zero using the IFERROR function.

example 2-4

Example #3

We can also find the growth or decline excel formula for a percentage. I have monthly sales for two months Jan and Feb 2018.

example 3

In Jan, sales were 53250, and in Feb, sales in 57500. It is clear that in Feb, sales are more. But the question is, what is the formula for the percentage of increase in excel in the sales when we compared to Jan.

Here we need to know what is the extra sale in Feb compares to Jan, i.e., Feb – Jan, then divide this variance by Jan sales.

example 3-1

Conclusion: In Feb sales, we use the formula for percentage increased in excel by 7.98% when we compared to Jan sales.

Percentage example 3-2

Things to Remember

  • We will get the error as #DIV/0! If the numerator is zero.
  • When we compare and find the growth or decline percentage, we get a negative percentage if the numerator or denominator value is less than zero.
  • We can get rid of errors in the percentage calculation by using the IFERROR function.
  • We need to change the formatting of the cells to display percentage values.

Recommended Articles

This has been a guide to Formula for Percentage in excel. Here we discuss how to calculate Percentage in excel using the IFERROR formula along with excel examples and downloadable excel templates. You may also look at these useful functions in excel –

  • Percentage Change Formula
  • Percentage Profit Formula
  • Calculate the Percentage Increase in Excel
  • Percentage Difference in Excel
7 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Download Coursera IPO Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Formula for Percentage Excel Template

Coursera IPO Financial Model & Valuation Free Download