H
HELP ME
i am using excel 2 calculate the amount of bonus that an employee i
entitled to. i do not know what function to use (i have been told 2 us
v lookup but i do not know how 2 go about it).
the exact problem is this:
there is a basic wage and on top of that an employee gets paid a bonus
this bonus is calculated by how many sales r made. the table of th
bonuses r given (below):
Commission on Qtrly Sales
Sales per Qtr Percentage
£200,000 and under 0.50
£300,000 and under 0.75
£400,000 and under 1.00
£500,000 and under 1.25
£600,000 and under 1.50
£700,000 and under 1.75
£800,000 and under 2.00
£900,000 and under 2.25
£1,000,000 and under 2.50
i was goin 2 uase an if statement but there r 2 many conditions.
i would b vvv greatful if someone could tell me how best 2 tackle thi
problem. if u could point me in the direction of a good website tha
would also b much appreciated.
thanks 4 ur help in advance
also i atached the file. the cells in yellow on the payments workshee
is where the formulat should go. it is all self explanotary. if u nee
more info on the prob then mail me ([email protected]) or jus
post.
thanks agai
Attachment filename: help-wages.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=39033
entitled to. i do not know what function to use (i have been told 2 us
v lookup but i do not know how 2 go about it).
the exact problem is this:
there is a basic wage and on top of that an employee gets paid a bonus
this bonus is calculated by how many sales r made. the table of th
bonuses r given (below):
Commission on Qtrly Sales
Sales per Qtr Percentage
£200,000 and under 0.50
£300,000 and under 0.75
£400,000 and under 1.00
£500,000 and under 1.25
£600,000 and under 1.50
£700,000 and under 1.75
£800,000 and under 2.00
£900,000 and under 2.25
£1,000,000 and under 2.50
i was goin 2 uase an if statement but there r 2 many conditions.
i would b vvv greatful if someone could tell me how best 2 tackle thi
problem. if u could point me in the direction of a good website tha
would also b much appreciated.
thanks 4 ur help in advance
also i atached the file. the cells in yellow on the payments workshee
is where the formulat should go. it is all self explanotary. if u nee
more info on the prob then mail me ([email protected]) or jus
post.
thanks agai
Attachment filename: help-wages.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=39033