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 is included. In this article, weâ€™ll discuss how to calculate the percentage of the budget spent in Excel.

**Table of Contents**hide

## How to Calculate Percentage of Budget Spent in Excel: 3 Simple Steps

Excel offers some simple steps to calculate the percentage of the budget spent. We just need to organize the information properly and use simple arithmetic formulas to calculate it. We 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.

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

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

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

## How to Calculate Percentage Increase of Budget

We can calculate the percentage increase of a budget very easily using Excel with a simple arithmetic formula. In the following dataset, we have column headers as Fiscal Year, Total Budget (Billion). We need to calculate the **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.

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

**Download Practice Workbook**

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

## Related Articles

- How to Calculate Error Percentage in Excel
- How to Calculate Cumulative Percentage in Excel
- How to Calculate Mean Percentage Error in Excel
- How to Calculate Remaining Shelf Life Percentage in Excel
- How to Calculate Percentage of Completion in Excel
- How to Calculate Utilization Percentage in Excel
- How to Calculate Absenteeism Percentage in Excel
- How to Calculate Savings Percentage in Excel
- How to Calculate Productivity Percentage in Excel
- How to Calculate Variance Percentage in Excel
- How to Calculate Accuracy Percentage in Excel
- How to Calculate Grade Percentage in Excel
- How to Calculate Win-Loss Percentage in Excel
- How to Calculate SLA Percentage in Excel