قالب وردپرس درنا توس
Home / Tips and Tricks / How to find percentage difference between values ​​in Excel

How to find percentage difference between values ​​in Excel



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,1
99 - $ 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.

  Sample data

Begin by selecting

  Select Cell G3

Type the following formula and then press Enter:

  = (F3-E3) / E3 

 Enter formula

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

  Formula result

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.

  Number Menu

The value is now formatted in percent with only one

  Formatted as percent with a decimal place

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.

 Fill cells down

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


Source link