Hi all,
looking for some help with a spread sheet.
For simplicities sake lets say I have 5 columns. Named:
Invoice Amount
PO Amount
Difference
10% of Invoice Value
Match

Invoice amount is obviously the amount my company has been invoiced
for.
PO Amount is what we calculated our internal Purchase order to be
Difference is the difference between Invoice and the Purchase order.
10% of Invoice Value is literally 10% of the comany invoice value.
Match is where I am having difficulty.

I work in a finance department, and have been asked to produce this
report. Basically if the difference between the invoice amount and the
PO amount is within 10% (above or below) we can pay it.

How would I calculate this using a excel formula? The contents of
Match afterwards should simply be set to "YES" or "NO" as other
functions rely on this output.

Thanks
Mick