Percentage Question

**John1950** · 03-16-2007, 08:26 AM

I have 2 sets of numbers and I want to find what the percentage of the difference between them is.

Cell A1 has 2500, B1 has 1066. I need a formula to find what the percentage difference between them is Please.

Thanks in Advance.

**arthurbr** · 03-16-2007, 08:33 AM

=(a1-b1)/b1 ( increase)

**John1950** · 03-16-2007, 08:52 AM

I entered =(A1-B1)/B1 Hit enter and got 149%. The actual number should be 42%. What am I doing wrong. Maybe I am getting confused somewhere.

**arthurbr** · 03-16-2007, 08:57 AM

And I get 134.52% which is the increase of 1066 to get 2500

**starguy** · 03-16-2007, 09:05 AM

Originally Posted by John1950

I have 2 sets of numbers and I want to find what the percentage of the difference between them is.

Cell A1 has 2500, B1 has 1066. I need a formula to find what the percentage difference between them is Please.

Thanks in Advance.

Hi try this

=(Max(A1:B1)-Min(A1:B1))/Min(A1:B1)

this will check percentage of increase no matter where is the increased amount (in cell A1 or B1).

**Bryan Hessey** · 03-16-2007, 09:23 AM

Originally Posted by John1950

I have 2 sets of numbers and I want to find what the percentage of the difference between them is.

Cell A1 has 2500, B1 has 1066. I need a formula to find what the percentage difference between them is Please.

Thanks in Advance.

Hi,

another way is

=(B1-A1)/A1

where a negative number shows a decrease, based on the first figure.

Starguy, I think you mistyped

=(MAX(A1:B1)-MIN(A1:B1))/MAX(A1:B1)

hth
---

**starguy** · 03-16-2007, 09:26 AM

Originally Posted by Bryan Hessey

Starguy, I think you mistyped

=(MAX(A1:B1)-MIN(A1:B1))/MAX(A1:B1)

hth
---

yes, I corrected it before your post. (just timings delay)

**John1950** · 03-16-2007, 09:33 AM

My apologies to all, I may have mislead everyone here.
the number 2500 is Items in a stockroom the number 1066 is the number of items that do not have a location in the stockroom yet. As time goes on these items will have a location but I have to report weekly what percentage of items dont have locations.
Sorry everyone.

**Bryan Hessey** · 03-16-2007, 09:34 AM

Originally Posted by starguy

yes, I corrected it before your post. (just timings delay)

it happens so often, but not so bad today as was yesterday.

I don't know where the 42% came from,

2500 & 1450 will give 42% based on the 2500

1513.7 and 1066 will give 42% based on the 1066

(the way an accountant would assess Sales profit)

hth
---

added just saw the post, 3566 & 1066 = 42%