# Percentage Differences

#### NTZ

##### New Member
I have two columns of figures. Column A is the selling price of a product and column B is my buying price. I need column C to show me the difference between the two as a pecentage and at the bottom of column C, I need it to show an average percentage difference between the two.

Many Thanks

NTZ

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
NTZ

Depends if you want the difference calculated as a percentage of Buy Price or Sell Price both solutions provided below.

Formula in C2 (copied down to C4) is:
=(A2-B2)/B2
D2 (copied down to D4) is:
=(A2-B2)/A2
C5 (copied across to D5) is:
Edit: =AVERAGE(C2:C4)

All these results cells formatted as percentage.
Mr Excel.xls
ABCDE
1Sell PriceBuy PriceDifference (cf Buy)Difference (cf Sell)
2201266.67%40.00%
315.231317.15%14.64%
4189.5887.89%46.78%
557.24%33.81%Average
6
Percentage Differences

Edit: Just make sure this is the 'Average' that you want. The 'Average' will be different if you total the Selling and Buying Prices and then calculate the percentage difference on these two totals.

Peter your a legend, will get back to you. This excel thing is all new to me, thanks for the speedy response.

Good work fella.

NTZ

Replies
2
Views
276
Replies
1
Views
164
Replies
3
Views
81
Replies
1
Views
68
Replies
0
Views
111

1,203,026
Messages
6,053,116
Members
444,640
Latest member
Dramonzo

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back