Microsoft Excel is powerful software. We can perform numerous tasks on our datasets using Excel tools and features. There are many default Excel functions that we can use to create formulas. Many educational institutions and business companies use Excel files to store valuable data. Sometimes, we have to carry out mathematical or statistical operations on Excel worksheets. In such cases, the percentage is very common, and we have to face and deal with it. A percentage is usually expressed with a % sign. This article will show you two easy ways to show one number as a percentage of another in Excel.
How to Show One Number as a Percentage of Another in Excel: 2 Easy Ways
Percentage is a Latin word. It means a hundred. Any number or ratio that we can express as a fraction of 100 is known as a percentage. We can show a number as a percentage in reference to another number, or a total of the numbers. It varies depending on the user’s requirements. The simple formula to calculate the percentage is
To illustrate, we’ll use a sample dataset. For instance, the following dataset contains Products, Ordered, and Delivered numbers. Here, we’ll represent the Delivered numbers as a percentage of Ordered.
1. Show One Number as a Percentage of Another with a Simple Calculation in Excel
In our first method, we’ll create a formula using the procedure demonstrated above. We won’t get to see the % icon in this example, as we’ll directly bring out the percentage value as the formula output. Therefore, follow the steps below to perform the task.
STEPS:
- First, select cell E5.
- Then, type the formula:
=(D5/C5)*100
- Subsequently, press Enter.
- Thus, it’ll return the output.
- Now, use AutoFill to get the results in the subsequent cells.
- See the picture below, where we have the required percentage values.
2. Apply Percentage Number Format in Excel for Showing One Number as a Percentage of Another
Moreover, we can ignore the multiplication by 100 portions in the formula to convert it to a percentage. In that case, we have to use the percentage number format. That will automatically transform the formula output to a percent. So, learn the following steps to carry out the operation.
STEPS:
- Firstly, click cell E5.
- Here, input the formula:
=(D5/C5)
- After that, press Enter.
- Subsequently, apply AutoFill to fill in the rest.
- Next, select the cell range D5:D9.
- Consequently, go to the Number section in the Home tab.
- There, choose the Percentage number format.
- Hence, you’ll see the accurate percentage outputs.
- Look at the figure below, where the results are similar to our 1st method.
Apply Formula for Percentage Increase in Excel
However, we may need to determine the percentage increase in many cases. This is mostly found in the year-wise sales of a certain product. Every company requires to find out the precise percentage change in their sales. In that way, they can take the necessary steps to improve if necessary. To illustrate, we’ll use the following dataset, which contains the Sales in 2020 & 2021 of some Products. Now, follow the below process to apply a formula for determining the percentage increase in Excel.
STEPS:
- First of all, choose cell E5.
- Insert the formula:
=(D5-C5)/C5
- Then, press Enter.
- Afterward, apply AutoFill.
- Subsequently, change the number format of the range D5:D9 to Percentage.
- Thus, you’ll see the value of a percentage increase in sales from 2020 to 2021.
- Here, notice that some of the amounts are negative numbers.
- This is because sales decreased for those products in 2021.
Get the Percentage of the Total in Excel
Again, you can also calculate the percentage of a number in the total value. In this regard, you will need to find the total first. For this example, we’ll use the below dataset as an example. So, learn the following process to carry out the operation.
STEPS:
- Select cell C10 first.
- Then, type the formula:
=SUM(C5:C9)
- Press Enter.
- The SUM function finds the total.
- Next, choose cell D5.
- Insert the formula:
=(C5/$C$10)
- After that, press Enter to get the output.
- Choose the Percentage number format to convert the results into percent.
- Accordingly, use AutoFill to complete the rest.
- Thus, it’ll express the ordered amounts in percent of the total.
Download Practice Workbook
Download the following workbook to practice by yourself.
Conclusion
Henceforth, you will be able to show one number as a percentage of another in Excel using the above-described methods. Keep using them, and let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.
Related Articles
- How to Calculate Percentage of Total in Excel
- How to Convert Number to Percentage in Excel
- How to Divide a Value to Get a Percentage in Excel
- How to Calculate Reverse Percentage in Excel
- How to Convert Percentage to Number in Excel
- How to Convert Percentage to Whole Number in Excel
- How to Add a Percentage to a Number in Excel
- Make an Excel Spreadsheet Automatically Calculate Percentage
- Convert Number to Percentage Without Multiplying by 100 in Excel