Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formulas
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formulas
=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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formulas
pippawl, Assumptions: Column A = entry of 15, 10 and 5 Column B = Value of the vaoucher You can use an IF formula =IF($A1=15,200,IF($A1=10,150,IF($A1=5,100,""))) This will give you your value of voucher depending on what is entered in column A Hope this Helps Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel considers my formulas as plain text | Excel Worksheet Functions | |||
How do you print showing formulas in Excel 2000? | Excel Discussion (Misc queries) | |||
Please help with Statistics Formulas in Excel | Excel Discussion (Misc queries) | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) |