CODEWITHSUNDEEP
excelexcel-formula
acmarston
acmarston

Reputation: 3

Excel get percentage of difference between numbers?

I'm trying to figure out how to add an equation in a cell which will give me the percentage of a number the difference between two numbers is. For example:

Cell A1: 154
Cell B1: 150

If I use this equation: 150 - 154, the answer is -4. What I need is an equation to give me what percentage of Cell A1 is Cell B1 - Cell A1. If that makes sense.

I've tried B1-A1/A1*100 and it gives me 50, but it's clearly not 50%.

I know it seems simple, but I can't seem to make it work for some reason.

Thanks.

Upvotes: 0

Views: 3244

Answers (1)

JvdV
JvdV

Reputation: 75870

To get a percentage difference between two values, the rule (at least the one I learned) is quite simple:

=(New value-Old value)/Old Value

So in your case it's as simple as:

=(A1-B1)/B1

Select the cell and format it as percentage

Obviously swap these cell references around if B1 holds the new value.

Upvotes: 2

Related Questions