# Help with a formula please

#### garethdraper

##### New Member
Hi Everybody, I hope someone can help me please?

I want to create a formula that will calculate the over/underspend on an invoice amount relevant to the PO amount, so say if Column A was £100 for the PO amount and Column B was £50 for the actual invoice amount how would I represent the £50 underspend on this in Column C? Also I need to incorporate overspend as well in the formula so it will show if Column B has spent more than Column A - is that possible?

Many thanks

Gareth

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

#### Titian

##### Well-known Member
PO Amount Actual spend £ difference % difference
100 70 30.00 30.0%
350 400 (50.00) (14.3%)

Formula in cell C2 = A2-B2
Formula in cell D2 = C2/A2
Formatting in column C is "#,##0.00_);[Red](#,##0.00)" without the ""
Formatting in column D is "0.0%;[Red](0.0%)" also without the ""

#### garethdraper

##### New Member
PO Amount Actual spend £ difference % difference
100 70 30.00 30.0%
350 400 (50.00) (14.3%)

Formula in cell C2 = A2-B2
Formula in cell D2 = C2/A2
Formatting in column C is "#,##0.00_);[Red](#,##0.00)" without the ""
Formatting in column D is "0.0%;[Red](0.0%)" also without the ""

Hi Titan, thanks for this but what I want are just the amounts that they are over or under not the % (ie: +50 or -50 if the invoice amount is over or under the PO amount) - does that make sense, if so how do I do it please?

Many thanks

#### Titian

##### Well-known Member
It's in column "C"

Replies
3
Views
1K
Replies
2
Views
377
Replies
5
Views
173
Replies
0
Views
247
Replies
14
Views
683

1,191,282
Messages
5,985,740
Members
439,978
Latest member
Mr930R

### 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.

### Which adblocker are you using?

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

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