How do I create a fomula that adds a percentage dependant on score???

Hi All,

I am new to this site and although I use excel every day I am struggling to write a formula!

I have a list of staff salaries and each person will be awarded a score of between 1-3 by their line manager, I then need to be able to add a percentage wage increase dependant on that score.

For example if they score 1 they will get 0.5% increase, but if they score 3 they get 1.5% increase.

They spreadsheet needs to be all tidy and easy for non-finance managers to look at so all they have to do is add the score and see what happens!

Sorry if this is really basic, but its confused me!

Many thanks

Name in Column B
Salary in Column C
Score in Column D

Formula in Column E:   =IF(AND(ISNUMBER(D5),D5<4,D5>0),C5*CHOOSE(D5,1.005,1.01,1.015),"")

'--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html