=LOOKUP(A1,{5,10,15},{100,150,200})
Or
=A1*10+50
"pippawl via OfficeKB.com" wrote:
I need to know if it is possible to create a formula for the following.
I am doing a spreadsheet for long service awards. The awardee receives eg.
£200 for 15 years, £150 for 10 years and £100 for 5 years. I have a column
with 15 in for the years, and one alongside with 200 and would like for each
row that every time I type 15 into the column for the amount of years, it
recognises that and fills £200 into the voucher column, and so on for 10 =
£150 & 5 = £100.
Is this possible and if so how do I create the formula?
Hope someone can help!!
Thanks,
P.
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200609/1