Percentage difference between two numbers

M

Michelle

I have two numbers that I need to calculate the percentage
of difference between them.

Example:
$1.22 increased to $1.30 = I need a formula that will tell
me the percentage of difference
 
P

Paul

Michelle said:
I have two numbers that I need to calculate the percentage
of difference between them.

Example:
$1.22 increased to $1.30 = I need a formula that will tell
me the percentage of difference
Click to expand...

Suppose your $1.22 is in A1 and $1.30 in A2.
The formula to calculate the percentage difference is
=A2/A1-1
Format this cell as percentage.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

difference in numbers displayed as a +/- percentage 3
Show Difference as a Percentage 1
How do you calculate a negative percentage 2
calculating percentages 8
percentages 2
Percentage increase of one cell to another in Excel? 4
Excel Average dates help 0
How do I get a cell to update itself based on the month we are in? 1

Top