S
slsjmc
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.
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.