Microsoft ‘s Excel is the most use software when it come performing calculations. assorted departments in many businesses use it, like report, inventory track, time log, and more .
It has many helpful built-in features like formulas and it helps you do accurate calculations .
In this article, we are going to go through how to use Excel to calculate percentage change, and besides how to find the addition and decrease in share values.
Let ‘s get into it .
What is Percentage Change?
percentage change is a concept in mathematics that represents changes that have occurred over fourth dimension. It is largely applicable in the sphere of accounting to compare old changes to raw ones .
In order to calculate percentage change in Excel, you ‘ll need to use a recipe. It ‘s the formula that that keeps track of different figures being worked on, like symmetry sheets, intersection prices, and others .
percentage change = (NEW - ORIGINAL) / ORIGINAL
How to Calculate Percentage in Excel
Let ‘s take a look at an model to get the understand of the formula at solve .
If your earnings are $ 1,250 in May and $ 1,750 in June, what is the share transfer ?
What we are trying to find in this question is the transfer that was made on the earnings from the month of May to June .
Using our formula :
percentage change = (NEW - ORIGINAL) / ORIGINAL hence: (1,750 - 1,250) / 1250 = 0.4 or 40%
now let ‘s take a look at how to do this in excel with a handful of data entries to better understand how excel functions work :
mistreat 1 : Data Entry.
Below we are presented with north excel workspace with some data, we are expected to calculate the share change as indicated in column
step 2 : The Formula.
In this case we will let A = Actual Price and B = Budget Price, indeed our convention will be : A/B-1. This rule will be entered in cellular telephone D2.
To execute the formula all we need to do is press Enter. We will get our share change in decimal fraction values like below :
If the number you get is positive, like 0.2, then the percentage increased. If the total is negative, like -0.2, then the percentage decreased .
step 3 : assign %.
In order to assign the
% sign to our values, we have a copulate of options. We can either :
- Right click on the values and select ‘%’, then drag the cursor down to apply changes to other values. Or
- Highlight the whole column ‘% Change’ and select the % sign from the Home menu, under numbers in the work sheet.
When calculating share change in excel, we have two options to work with that is ; we are either calculating percentage increase or decrease. Let ‘s take a look on how to work on this :
How to Calculate Percentage Increase
In order to calculate percentage increase, you will need to figure out the difference between the two numbers you are comparing meaning you will need the Original details and the Newly added ones.
Read more: How to Tie a Tie: 7 Knots for All Occasions
In this case our formula will be divided into two steps :
increase = (NEW - ORIGINAL)
The future step will be dividing the increase by the original number and multiplying it by 100 to get the share prize .
percentage increase = Increase ÷ Original Number × 100.
If the number you get is negative, like -0.10, then the share actually decreased rather than increased .
Your family bill was $ 100 in September, but increased to $ 125 in October. What is the percentage addition from September to October ?
Referencing to our formula above, foremost we will need to get the increased prize then convert it into percentage .
increase = (NEW - ORIGINAL) hence: increase = (125 - 100 = 25) then: percentage increase = Increase ÷ Original Number × 100. % increase = 25 ÷ 100 × 100 = 25%
As described earlier when calculating share change in excel, the same steps will be followed in the case of share deepen .
How to Calculate Percentage Decrease
The same procedure we applied when calculating percentage addition will be applied here, the only difference will be this time round off we will be subtracting the master value from newly one .
Decrease = Original Number - New Number
The future step you divide the respect you got as a decrease by the original number and multiply by 100 to get the % value .
Percentage Decrease = Decrease ÷ Original Number × 100
If the issue you get is minus, like -0.10, then the percentage actually increased preferably than decreased .
In the former year, your expenses were $ 500,000. This year, your expenses were $ 400,000. What is the percentage decrease of your expenses this class compared to last year ?
The inaugural step is for us to get the decrease value, which will easily guide us into getting the share respect of the lapp .
Decrease = Original Number - New Number therefore: Decrease = (500,000 - 400,000) = 100,000 hence: Percentage Decrease = Decrease ÷ Original Number × 100 % Decrease = 100,000 ÷ 500,000 × 100 = 20%
possibly you might wonder how do I go about the lapp on an excel worksheet ? well here is a pictorial theatrical performance and working f the lapp :
There you have it, the above illustrated methods will works no topic what sum of data you have at hand .
now when working with softwares you are not always guaranteed success, you are bount to encounter some errors. Below are some of the most ones which you are likely to encounter and how to solve them .
Common Excel Errors When Using Formulas
- #DIV/0!: Occurs if you attempt to divide a number by zero. To solve this problem change the divider into a number that is not zero.
- #VALUE: Occurs when cells are left blank, or when a function is expecting a number but you pass it text instead.
- NUM!: Occurs when a formula contains invalid numeric values.
- ####: Occurs when the values are too many to display in the assigned column. The solution is to expand the respective column.
- #Name?: If you type wrong values in the formula, like misspelling of a function. To fix it write correct formula names.
- #REF!: Occurs when you are referencing cells that are not valid or deleting cells that have been referred to in a formula. To fix this, refers cells correctly.
now, with this cognition you should be able to work yourself around share exchange calculations. Do you have anybody in mind who might benefit with the cognition captured here, do share the article with them .
here is a quick retread of what we have discussed :
- In percentage change calculations we need at-least two values.
- Percentage change can be either a positive or a negative number.
- If the number you get in % decrease is negative then the percentage actually increased rather than decreased.
- If the number you get in % increase is negative, then the percentage actually decreased rather than increased.
here are a few resources to help you get a better understand of working with Excel .
happy Coding ❤