Help with a formula please

[garethdraper]

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

 

[Titian]

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]

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]

It's in column "C"