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 |
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) |