automatically insert salary based on job title
I have an Excel worksheet with a column indicating approx. 11
different positions (this number will probably increase). I would
like Excel to automatically insert a salary in one column based on the
job title inserted in the column prior.
e.g.
Supervisor typed in one column with automatically insert the salary in
the next column $100,000.00
Foreman typed in will automatically insert $75,000.00 in the next
column (Salary column)
Labour - $50,000.00 will insert in next column
Labour + 10 yrs will insert $55,000.00
Labour + 20 yrs will insert $60,000.00
etcetera....
I am a basic Excel user and have been trying IF as well as IF AND and
have been getting a lot of errors.
I would also be interested in a column that has a person with a Labour
title, automatically change to Labour+ 10 yrs, once the 10 years from
the start date has been reached. This would then change the salary
automatically (per above) to an increased amount.
Thank you.
|