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.

**Table of Contents**hide

## 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

**% = (Number Ã· Reference Number or Total) * 100**

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