garethdraper
New Member
- Joined
- Nov 22, 2016
- Messages
- 5
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
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