Entri Blog
No Result
View All Result
Wednesday, March 22, 2023
  • State PSC
    • Kerala PSC
    • TNPSC
    • APPSC
    • TSPSC
    • BPSC
    • Karnataka PSC
    • MPPSC
    • UPPSC
  • Banking
    • IBPS PO Notification
    • IBPS Clerk Notification
    • SBI PO Notification
    • SBI Clerk Notification
    • SBI SO Notification
    • SBI Apprentice Notification
    • Canara Bank PO Notification
    • Indian Bank PO Notification
    • RBI Assistant Notification
    • RBI Office Attendant Notification
    • IBPS RRB Notification
    • IBPS RRB Office Assistant Notification
  • Govt Exams
    • Railway
    • SSC
  • Skilling
    • Coding
    • Spoken English
    • Stock Marketing
  • TET
    • APTET
    • CTET
    • DSSSB
    • Karnataka TET
    • Kerala TET
    • KVS
    • MPTET
    • SUPER TET
    • TNTET
    • TSTET
    • UPTET
  • Courses
    • Data Science Course
      • Data Science Malayalam
    • Full Stack Developer Course
      • Full Stack Development Malayalam
      • Full Stack Development Hindi
      • Full Stack Development Tamil
      • Full Stack Development Telugu
      • Full Stack Development Kannada
  • Others
    • GATE
    • MAT
    • KMAT
Free English Quiz: Try Now!
Entri Blog
  • State PSC
    • Kerala PSC
    • TNPSC
    • APPSC
    • TSPSC
    • BPSC
    • Karnataka PSC
    • MPPSC
    • UPPSC
  • Banking
    • IBPS PO Notification
    • IBPS Clerk Notification
    • SBI PO Notification
    • SBI Clerk Notification
    • SBI SO Notification
    • SBI Apprentice Notification
    • Canara Bank PO Notification
    • Indian Bank PO Notification
    • RBI Assistant Notification
    • RBI Office Attendant Notification
    • IBPS RRB Notification
    • IBPS RRB Office Assistant Notification
  • Govt Exams
    • Railway
    • SSC
  • Skilling
    • Coding
    • Spoken English
    • Stock Marketing
  • TET
    • APTET
    • CTET
    • DSSSB
    • Karnataka TET
    • Kerala TET
    • KVS
    • MPTET
    • SUPER TET
    • TNTET
    • TSTET
    • UPTET
  • Courses
    • Data Science Course
      • Data Science Malayalam
    • Full Stack Developer Course
      • Full Stack Development Malayalam
      • Full Stack Development Hindi
      • Full Stack Development Tamil
      • Full Stack Development Telugu
      • Full Stack Development Kannada
  • Others
    • GATE
    • MAT
    • KMAT
No Result
View All Result
Entri Blog
English Quiz
banner top article banner top article
Home Articles

How to Calculate Percentage in Excel?

by Sreevidya M
March 20, 2023
in Articles, Data Science and Machine Learning, Entri Skilling
Calculate Percentage in Excel
Share on FacebookShare on WhatsAppShare on Telegram

Table of Contents

  • How to Calculate Percentage in Excel?
  • Calculating Percentage Change in Excel
  • Increasing or Decreasing a Number by a Percentage
  • Calculate Percentage in Excel FAQs

Excel is used for many kinds of data management. Calculating percentages is one of the essential calculations that you have to perform when it comes to interest rates, profit and loss, discounts, statistics, comparing quantities and even tax calculation. A percentage is a representation of parts per hundred of a quantity. It is usually calculated by dividing the numerator by the denominator and then multiplying the result by a hundred. In this blog, we will learn how to calculate percentage in Excel along with formula examples for percentage calculations.

Ready to upgrade your data science skills? Sign up for a free demo today!

How to Calculate Percentage in Excel?

There are 2 methods for finding percentages in Excel.

Method1: Calculate Percentage in Excel using Basic Percentage Formula

The basic formula to calculate percentage in excel is given below.

(Part/whole)= percentage

You must have noticed that the Excel formula lacks the step multiplied by 100. This is because we don’t have to multiply the result by 100 as applying percentage format to a cell does this calculation without manual prompts. Follow the steps given below to calculate percentage in excel.

  • Click on a blank cell.
  • Enter x/y in a cell.
  • Press return. The result will appear as a decimal in a cell.
  • Select the cell with the result.
  • Click on the home tab.
  • Select the number group.
  • Select the percentage style button.
  • To change the number of decimal points shown, click on increase decimal or decrease decimal button as you need.

An example is provided here for a better understanding of the concept.

– A B C D
1 Student Marks obtained Total marks Percentage
2 Ram 20 50 20/50
3 Seta 40 50 40/50

Here the formula is given to the cells D2 and D3 to get results. Then it is changed into a percentage style using the steps discussed above.

Method2: Calculate Percentage in Excel using Shortcut

In the case of using a shortcut for calculating percentages in excels, all the steps are identical till pressing return to get the result. Then use the shortcut ctrl+ shift+ % after clicking on the obtained result.

Looking for a best Data Science Career? Explore Here!

Calculating Percentage Change in Excel

There are instances where we need to calculate the percentage change in certain values. For example, there is a pay rise for your work this month. Then you can compare it with the previous salary by calculating the percentage change.

The Excel formula for calculating the percentage change is:

(New value- old value)/ Old value

If the value is positive then it is a percentage increase and if the value is negative it is a percentage decrease.

What you have to do is click a blank cell and apply this formula. Then press return. After that, you can use either method 1 or method 2 to get the appropriate result i.e. the percentage change. An example is illustrated below.

– A B C D
1 Country   Bread prices in 2022 Bread prices in 2023 Percentage change
2 India 25 35 (35-25)/25
3 Nepal 20 30 (30-20)/20

Here the formula is applied in the cells D2 and D3. Then you should press the return button for results. Then it is changed into a percentage style using the steps discussed above.

Increasing or Decreasing a Number by a Percentage

There are operations in which a number is increased by a certain percentage. For example, the price of bread is x in the market. Next week it increases by y%. The new value can be found by using the formula:

[1+(y/100)] * Original value

When there is a y% decrease, the new value can be found using the formula:

[1-(y/100)] * Original value

After applying either of the above formulas according to the situation you have to press returns.

An example is given below for further comprehension of the concept.

– A B C D
1 Item     Prices in 2022 Percentage of increase in 2023 New price 
2 Milk 25 5% [1+0.05]* 25
3 Butter 20 6% [1+0.06]* 20

Here the Excel formula is applied to the cells D2 and D3. Results can be obtained by pressing the return button. Then we have to change it into currency by using the steps provided below.

In older versions

  • Select the cell with the result.
  • Click on the home button
  • Click on the dollar icon to choose from options in the drop-down.

In Excel for Mac 2011

  • Choose the cell with the result.
  • Select the home tab.
  • Choose the number button.
  • Click on the currency and select from the options.

The information provided in this article will help you in understanding the procedure needed to calculate percentage in excel. Manually finding the percentages is time-consuming work, especially when it comes to a bulk amount of data. Excel formulas provided here will help you get the work done easily.

Learn Data Science from Expert Mentors. Take Demo classes for free!

Calculate Percentage in Excel FAQs

1. What is the basic formula for percentage? How is it different from the Excel formula for percentages?

The basic percentage formula is (part/total)* 100. But the Excel formula for percentage is Part/total. The “multiplied by 100” part is omitted because the result after running the excel formula will be automatically shown as a percentage as the cell is changed into percentage format.

2. What is the Excel formula for the percentage shortcut?

The shortcut for the percentage formula in excel is ctrl+ shift+ %

3. What is the formula for percentage change in Excel?

The formula for percentage change in Excel is (New value- old value)/ Old value.

 

Related links

Keyboard Shortcuts in Excel for Data Entry Excel Interview Questions and Answers 2023
Top 10 Advanced Excel Formulas How to Use VLOOKUP in Excel – Step by Step Guide
Naive Bayes Classifier in Machine Learning Data Wrangling in Machine Learning
Big Data Analytics – Importance, Applications, Examples Data Analysis – Methods, Process, Types
Share61SendShare
Sreevidya M

Sreevidya M

Post-Graduate in English Language and Literature, freelance writer and an SSC aspirant. Provides updates on notifications, syllabuses and dates for government exams.

Related Posts

MP SET 2023 Syllabus and New Exam Pattern
Articles

MP SET 2023: Syllabus and New Exam Pattern PDF

March 16, 2023
Kerala PSC Assistant Professor Interview Call Letter 2023 Out: Check Link
Articles

Kerala PSC Assistant Professor Interview Call Letter 2023 Out: Check Link

March 16, 2023
Kerala PSC Drawing Teacher Shortlist 2023 Out: Check PDF, Download Link
Articles

Kerala PSC Drawing Teacher Shortlist 2023 Out: Check PDF, Download Link

March 16, 2023

Discussion about this post

Latest Posts

  • Simple Present Tense Exercises
  • Kerala PSC Assistant Surgeon Syllabus and Exam Pattern 2023 – Download PDF
  • Kerala PSC Assistant Surgeon Previous Question Paper
  • TNPSC MVI Oral Test Date 2023, Download Selection List PDF
  • Kerala PSC Assistant Surgeon Notification 2023 Out: Download PDF

Trending Posts

  • states of india and their capitals and languages

    List of 28 States of India and their Capitals and Languages 2023 – PDF Download

    150163 shares
    Share 60062 Tweet 37539
  • List of Government Banks in India 2023: All you need to know

    61652 shares
    Share 24661 Tweet 15413
  • TNPSC Group 2 Posts and Salary Details 2022

    39657 shares
    Share 15863 Tweet 9914
  • KSDA Recruitment 2023 Apply Online for 9264 FDA SDA Posts – Qualification

    1711 shares
    Share 684 Tweet 428
  • New Map of India with States and Capitals 2023

    28708 shares
    Share 11483 Tweet 7177

Courses

  • Data Science Course
  • Full Stack Developer Course
  • Data Science Course in Malayalam
  • Full Stack Developer Course in Malayalam
  • Full Stack Developer Course in Hindi
  • Full Stack Developer Course in Tamil
  • Full Stack Developer Course in Telugu
  • Full Stack Developer Course in Kannada

Company

  • Become a teacher
  • Login to Entri Web

Quick Links

  • Articles
  • Videos
  • Entri Daily Quiz Practice
  • Current Affairs & GK
  • News Capsule – eBook
  • Preparation Tips
  • Kerala PSC Gold
  • Entri Skilling

Popular Exam

  • IBPS Exam
  • SBI Exam
  • Railway RRB Exam
  • Kerala PSC
  • Tamil Nadu PSC
  • Telangana PSC
  • Andhra Pradesh PSC
  • MPPSC
  • UPPSC
  • Karnataka PSC
  • Staff Selection Commission Exam

© 2021 Entri.app - Privacy Policy | Terms of Service

No Result
View All Result
  • State PSC
    • Kerala PSC
    • TNPSC
    • APPSC
    • TSPSC
    • BPSC
    • Karnataka PSC
    • MPPSC
    • UPPSC
  • Banking
    • IBPS PO Notification
    • IBPS Clerk Notification
    • SBI PO Notification
    • SBI Clerk Notification
    • SBI SO Notification
    • SBI Apprentice Notification
    • Canara Bank PO Notification
    • Indian Bank PO Notification
    • RBI Assistant Notification
    • RBI Office Attendant Notification
    • IBPS RRB Notification
    • IBPS RRB Office Assistant Notification
  • Govt Exams
    • Railway
    • SSC
  • Skilling
    • Coding
    • Spoken English
    • Stock Marketing
  • TET
    • APTET
    • CTET
    • DSSSB
    • Karnataka TET
    • Kerala TET
    • KVS
    • MPTET
    • SUPER TET
    • TNTET
    • TSTET
    • UPTET
  • Courses
    • Data Science Course
      • Data Science Malayalam
    • Full Stack Developer Course
      • Full Stack Development Malayalam
      • Full Stack Development Hindi
      • Full Stack Development Tamil
      • Full Stack Development Telugu
      • Full Stack Development Kannada
  • Others
    • GATE
    • MAT
    • KMAT

© 2021 Entri.app - Privacy Policy | Terms of Service