H
HELP ME
the aim is 2 work out how much a bonus an employee is owed. it is
worked out like this:
"If an individual salesperson achieves sales equal to or exceeding the
target figure in any *one* quarter, the bonus is equal to 0.5% of the
total sales value achieved over the entire year. If sales equal or
exceed the target figure in two or more quaters, the bonus is equal to
1.0% of the total sales value achieved over the entire year."
i know i need to use a lookup function but which 1???????
and how do i apply it. i have attached the file and any help would be
vvvv useful!!!!!!!!!!!!!
Attachment filename: bonus.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=391605
worked out like this:
"If an individual salesperson achieves sales equal to or exceeding the
target figure in any *one* quarter, the bonus is equal to 0.5% of the
total sales value achieved over the entire year. If sales equal or
exceed the target figure in two or more quaters, the bonus is equal to
1.0% of the total sales value achieved over the entire year."
i know i need to use a lookup function but which 1???????
and how do i apply it. i have attached the file and any help would be
vvvv useful!!!!!!!!!!!!!
Attachment filename: bonus.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=391605
