Hi there,
I am new to this forum (1st Post) and also new to excel.
I am currently doing my bookkeeping course and i am stuck on a question and need some help.
The exercise asks me to create a multiple nested IF statements (with the average function nested in the IF statement) in column F to display the bonus as a percentage based on the rewards system they have in place for average sales for the 4 weeks.
This is what is should look like when finished.
<tbody>
</tbody>
Can anyone please me what formula i would use if column F line 2 to get that answer.
PLEASE PLEASE PLEASE
I am new to this forum (1st Post) and also new to excel.
I am currently doing my bookkeeping course and i am stuck on a question and need some help.
The exercise asks me to create a multiple nested IF statements (with the average function nested in the IF statement) in column F to display the bonus as a percentage based on the rewards system they have in place for average sales for the 4 weeks.
This is what is should look like when finished.
Employee | Week 1 | Week 2 | Week 3 | Week 4 | Bonus (%) | Bonus Amount |
Kina | $2,000.00 | $2,000.00 | $4,000.00 | $3,333.00 | 7% | $198.33 |
Bina | $1,000.00 | $2,345.00 | $2,000.00 | $2,121.00 | 3% | $56.00 |
Tina | $2,500.00 | $2,000.00 | $2,345.00 | $1,000.00 | 3% | $58.84 |
Lina | $4,000.00 | $3,214.00 | $2,000.00 | $4,000.00 | 10% | $330.35 |
Gina | $800.00 | $1,800.00 | $1,000.00 | $1,500.00 | 0% | No Bonus |
<tbody>
</tbody>
Can anyone please me what formula i would use if column F line 2 to get that answer.
PLEASE PLEASE PLEASE