Thread
:
10% Match
View Single Post
#
4
Posted to microsoft.public.excel.programming
Stephen Wortley
external usenet poster
Posts: 4
10% Match
Hi Mick
The formula to use is =IF((D1-ABS(C1))0, "Yes","No")
Where D1 is the cell ref for 10%... and C1 is the Cell ref for
Difference
The way to "read" this is "If the 10% limit minus the difference is
positive (i.e. within limit), then "Yes", else "No"
Hope this helps
Stephen Wortley
(Materialised[Work]) wrote in message . com...
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
Reply With Quote
Stephen Wortley
View Public Profile
Find all posts by Stephen Wortley