Home ALL NEWS & INFO TECHNOLOGY How to Find the Percentage of Difference Between Values in Excel

How to Find the Percentage of Difference Between Values in Excel

46
0
How to Find the Percentage of Difference Between Values in Excel How to Use Conditional Formatting to Find Duplicate Data in Excel Concatenate in Microsoft Excel Insert Excel Table Into Word With VBA How to List and Sort Unique Values and Text in Microsoft Excel When you want a list of customers, email addresses, product IDs, or something similar where each one is distinct, Excel has a function to help. We’ll show you how to use this function to list unique values and text.

How to Find the Percentage of 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 to be able to calculate things like how much the price of gas changed overnight or the percentage of a stock price’s rise or fall.

How Percentage of Change Works

The percentage of change 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 drive home and it rose to $3.199 this morning when you filled your tank, you could calculate the percentage of change by plugging those values into the formula.

($3.199 - $2.999)/($2.999) =  0.067 = 6.7%

Let’s Look at an Example

For our simple example, we will look at a list of hypothetical prices and determine the percentage of change between an original price and a new price.

Here is our sample data containing three columns: “Original Price,” “New Price,” and “Percentage of Change.”  We have formatted the first two columns as dollar amounts.

Example Data

Select Cell G3

Type the following formula and then press Enter:

=(F3-E3)/E3

Enter Formula

The result will appear in the cell.  It is not formatted as a percentage, yet. To do that, first select the cell containing the value.

Formula Result

In the “Home” menu, navigate to the “Numbers” menu. We will use two buttons—one to format the cell value as a percentage and another to reduce the number of decimal places so that the cell only shows the tenths place.  First, press the “%” button.

Next, press the “.00->.0” button.  You can use either 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 as a percentage with only one decimal place displayed.

Formatted As Percent With One Decimal Place

RELATED ARTICLES

Basic Excel Functions Everybody Should Know
Essential Microsoft Excel Functions for Budgeting
Ways to Concatenate in Microsoft Excel
How to List and Sort Unique Values and Text in Microsoft Excel
How to Make One Page Landscape in Microsoft Word
Ways How to Rearrange Pages in Word
How to Make a Table of Contents in Word
How to Add Numbers in Microsoft Excel
How to Use Conditional Formatting to Find Duplicate Data in Excel
How to Find the Percentage of Difference Between Values in Excel
How to Compare Two Lists in Microsoft Excel

LEAVE A REPLY

Please enter your comment!
Please enter your name here