It's been a little while since I've used Excel and I am having trouble writing out this formula. The formula has to follow these 3 criteria:
Calculate each employee’s bonus amount on Tab 1 and enter the bonus amount under column named Bonus Received by following instruction below.
- Bonus received is $250 for employee whose hour is equal to or greater than 2080 hours.
- Bonus received for employee whose hour is between 200 – 2079 is total hours worked divided by 2080 times $250.
- Bonus received is 0 for employees with less than 200 hours.
It is the 2nd criteria I am having trouble entering into my nested IF function.
Any help would be greatly appreciated!
