Calculate Percentage in Excel


Home >> How to Use Excel Tutorial >> Excel Calculations >> Calculate Percentage in Excel



In this part of Compute Expert blog tutorial, you will learn about how to calculate percentage in excel. There is no built in percentage formula in excel which can be used directly to calculate percentage in excel. Because of that, we will calculate percentage in excel manually before the result is converted to the number form desired.


Why We Need to Learn About How to Calculate Percentage in Excel?


This type of calculation is needed when you need to see comparison between two numbers in the form of a digit. Often this number form becomes a practical way to see data comparison as it is just simpler and easier to understand by people who see it.

For example, let’s say you want to see product A sales digit in comparison to all product sales in a company. If we say it is 20% for the comparison then it will be known for most people that the sales of product A number is roughly 20 compared 100 or a fifth from the whole sales. This form is often used in representing various kinds of number comparison, such as comparison of employee productivity, target and achievement, profit to revenue, and others.

If you often process number data in this spreadsheet tool, then knowing how to calculate percentage in excel by understanding the writing of percentage formula in excel will be very helpful. Percentage formula in excel is like a manual calculation but it is helped by the automatic calculation process in the software and the result can also be used for the process with other number in this spreadsheet software so it will make the analysis with your data will be much effective and efficient generally.


What is Calculate Percentage in Excel?


Calculate percentage in excel is writing the percentage formula in excel to help drawing comparison between two digit data. The result of percentage formula in excel itself usually needs to be changed again so that the form of the digit can be as expected. The writing of percentage formula in excel and the changing process of the result to the expected form are what will be explained in the next part of this tutorial.


How to Calculate Percentage in Excel?


Next part will explain about the way to calculate percentage in excel. Calculate percentage in excel itself, as has previously been explained, is by writing the percentage formula in excel manually before changing it to the wanted form of number (with the % sign). The result of this process can be used further for calculation with other numbers in this spreadsheet software.

This percentage formula in excel use division process inside of it. Because of that, it is better if you are already familiar with the division process in this spreadsheet software which can be learned in the other part of this Compute Expert blog tutorial.


Write Percentage Formula in Excel to Calculate Comparison Between One Number and Another

  1. Type equal sign ( = ) in the cell where you want to put this process result

    Calculate Percentage in Excel - Screenshot of Step 1-1

  2. Type the number or cell coordinate where the number which want to be processed is after = then input slash sign ( / )

    Calculate Percentage in Excel - Screenshot of Step 1-2

  3. Type the number or cell coordinate where the comparison number is after slash sign

    Calculate Percentage in Excel - Screenshot of Step 1-3

  4. Press Enter
  5. Place cursor in the cell where the division process is and click on Percent Style menu on Home tab.

    Calculate Percentage in Excel - Screenshot of Step 1-5

  6. The process is done for your number!

    Calculate Percentage in Excel - Screenshot of Step 1-6




Write Percentage Formula in Excel to Calculate Comparison from a Number Change

  1. Type equal sign ( = ) in the cell where you want to put the process result

    Calculate Percentage in Excel - Screenshot of Step 2-1

  2. Type open bracket sign, then number or cell coordinate where the before/after change digit is (depends on which is bigger) followed by minus sign ( - )

    Calculate Percentage in Excel - Screenshot of Step 2-2

  3. Type number or cell coordinate where the before/after change digit is (depends on which is smaller) followed by close bracket sign

    Calculate Percentage in Excel - Screenshot of Step 2-3

  4. Type slash sign ( / ) followed by before change number or cell coordinate where that number is

    Calculate Percentage in Excel - Screenshot of Step 2-4

  5. Press Enter
  6. Place cursor in the cell where the division process is and click on Percent Style menu on Home tab.

    Calculate Percentage in Excel - Screenshot of Step 2-6

  7. The process is done for your number!

    Calculate Percentage in Excel - Screenshot of Step 2-7



Exercise


After you have learned how to calculate percentage in excel by writing percentage formula in excel, you can practice your understanding after learning through this exercise!

Download file from below link and answer the questions. Download the answer when you have done the calculation of percentage formula in excel and sure about the answer!

Link to download file to train your understanding of using percentage formula in excel method:
Download here

Questions

  1. What is the comparison between achievement and target?
  2. How much gap is still needed to be closed between achievement and target?

Answer download link
Download here


Additional Notes


To increase or decrease decimal number from the percentage formula in excel process result, you can use increase decimal/decrease decimal menu from Home tab after putting the cursor in the cell where the result is.

Calculate Percentage in Excel - Screenshot of Decimal Tips 1



Or right click after putting the cursor to the cell where the result which decimal is wanted to be changed is, click Format Cells, and on the Number tab pick Number to then change the value on the Decimal Places based on the decimal number you want before clicking OK.

Calculate Percentage in Excel - Screenshot of Decimal Tips 2-1



Calculate Percentage in Excel - Screenshot of Decimal Tips 2-2



But you must remember that this method only changes the decimal look of the result. If you really want to change the value, then you need to practice round function in this spreadsheet tool. The tutorial of this process is also in this blog.



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert