If you are looking for **how to calculate the percentage of budget spent in Excel**, then you are in the right place. Every independent nation as well as different organizations makes their budget every year where each and every detail of financial income and expenditure are included. In this article, weâ€™ll discuss how to calculate the percentage of the budget spent in Excel.

**Table of Contents**hide

## Download Practice Workbook

## Steps to Calculate Percentage of Budget Spent in Excel

Excel offers some simple steps to calculate the percentage of budget spent. We just need to organize the information properly and use simple arithmetic formulas to calculate it. We just need to follow the steps below.

### 1. Determining Budget Sectors

In the first step, we need to specify the budget sectors. A countryâ€™s budget includes many sectors necessary for the proper running of that country. Here, in the following dataset, we have included **9** different budget sectors in **Column B**.

Weâ€™ll find out the percentage spent on these sectors.

**Read More: ****How to Apply Percentage Formula for Multiple Cells in Excel (5 Methods)**

### 2. Input the Budget of Different Sectors

Secondly, in this step, we have to include the **Budget (Million)** of the mentioned sectors. We need to collect them from the countryâ€™s annual budget data. Here, the **Budget **is placed in **Column C**.

**Read More: ****Calculate Percentage in Excel VBA (Involving Macro, UDF, and UserForm)**

### 3. Determining Budget Spent

Thirdly, we need to add the budget spent in **Column D**. You can collect these data from the annual budget data.

**Read More: ****How to Use IF and Percentage Formula in Excel (2 Easy Ways)**

**Similar Readings**

**How to Calculate Percentage of Percentage in Excel (2 Examples)****Calculate Annual Growth Rate in Excel (3 Methods)****How to Calculate Percentage of Completion in Excel (3 Methods)****Calculate Gross Profit Margin Percentage with Formula in Excel****How to Show One Number as a Percentage of Another in Excel**

### 4. Calculating Percentage of Budget Spent

This step is the primary step to calculate the percentage of the budget spent.

Firstly, write the following formula in the **E5 **cell like this.

`=D5/C5`

Here, **D5 **and **C5 **refer to the **Budget Spent** and **Budget** in **Education**.

Secondly, press **ENTER **to get the output as **0.5**.

Thirdly, use the **Fill Handle** by dragging down the cursor while holding the **right-bottom** corner of the **E5 **cell like this.

Eventually, weâ€™ll get the output like this.

Fourthly, select the cells **E5:E13** > go to **Home **> click **%** sign in the **Number **box.

Consequently, the output is like this.

**Read More: ****Percentage Formula in Excel (6 Examples)**

## How to Calculate Percentage Increase of Budget

We can calculate the percentage increase of a budget very easily using Excel with simple arithmetic formula. In the following dataset, we have column headers as Fiscal Year, Total Budget (Billion). We need to calculate **Percentage Increase** in **Column D**. We just need to follow some simple steps.

Firstly, write the following formula in the **D6 **cell like this.

`=(C6-C5)/C5`

Here, **C6 **and **C5 **refer to the Total Budget of **$145** and **$130** respectively.

Secondly, press **ENTER **to get the output and then use the **Fill Handle** to get other outputs like this.

Thirdly, select the cellsÂ **D6:D10** > go to **Home **> click** %** sign in the **Number **box.

Finally, weâ€™ll get a percentage increase like this.

**Read More: ****How to Calculate Growth Percentage with Formula in Excel**

## How to Calculate Percentage Decrease of Budget

We can also calculate percentage decreases by using Excel. Suppose, we need to find out the percentage change in **Column D** which has a column header as** Percentage Decrease**.

Firstly, write the formula in the **D5 **cell.

`=(C6-C5)/C5`

Here, **C6 **and **C5 **refer to the **Total Budget** of **$120** and **$130** respectively.

Secondly, press **ENTER **and use the **Fill Handle** to get the output like this.

Here, the outputs are negative which actually means the percentage change is negative. It actually means the percentage decreases.

Now, select the cells **D6:D10** > go to **Home **> click **%** sign in the **Number **box.

Eventually, the negative percentage increase i.e. percentage decrease is like this.

**Read More: ****How to Calculate Minus Percentage in Excel (2 Methods)**

## Conclusion

Thatâ€™s all about todayâ€™s session. And these are the ways to calculate the percentage of the budget spent in Excel. We strongly believe this article would be highly beneficial for you. Donâ€™t forget to share your thoughts and queries in the comments section and explore our website **ExcelDemy**, a one-stop Excel solution provider.

## Related Articles

**Calculate Percentage in Excel Based on Cell Color (4 Methods)****How to Calculate Percentage of a Number in Excel (5 Easy Ways)****Calculate Total Percentage in Excel (5 Ways)****How to Calculate Average Percentage in Excel (3 Easy Methods)****Percentage Difference Between Two Percentages in Excel****How to Use Excel Formula to Calculate Percentage of Grand Total****Calculate Contribution Percentage with Formula in Excel**