You can use Excel to calculate the percentage of change between two values quickly. In our simple example, we show you what you need to know in order to calculate things such as how much the gas price changed overnight or how large a share of the share price rises or falls.
How the percentage of changes works
The proportion of changes between an original and a new value is defined as the difference between the original value and the new value divided by the original value.
(new_value - original_value) / (original_value)
For example, if the price of a gallon of gasoline was $ 2,999 yesterday on your device at home and it rose to $ 39999 this morning when you filled your tank, you can calculate the percentage of change by connecting these values to the formula.
($ 3,199 - $ 2,999) /($2,999) = 0,067 = 6,7%
Let's look at an example
For our simple example, we will see a list of hypothetical prices and determine the percentage of change between an original price and a new price. 19659009] Here are our sample data with three columns: "Original price", "New price" and "Percentage of change". We have formatted the first two columns as dollar amounts.
Begin by selecting
Type the following formula and then press Enter:
= (F3-E3) / E3
] The result will be displayed in the cell. It is not formatted as a percentage, yet. To do so, first select the cell containing the value.
In the "Home" menu, navigate to the "Numbers" menu. We will use the two buttons to format the cell value in percent and another to reduce the number of decimals so that the cell only shows the tenth place. First press the "%" button. Then press the ".00 ->. 0" button. You can use any of the buttons on the right side of the menu to increase or decrease the displayed precision of the value.
The value is now formatted in percent with only one
Now we can calculate the percentage of change for the remaining values.
Select all cells in "Percentage of change column and then press Ctrl + D. Ctrl + D shortcut fills data down or right through all selected cells.
Now we finished, all percentages of change between the original prices and the new prices have been calculated. Note that when the value "New price" is lower than the "Original price" value, the result is negative.
RELATED: All the best Microsoft Excel keyboard shortcuts