File Home Insert Insert Draw Home Page Layout Formulas Data Review View Developer Help B Share Comme Insert Century Gothic v11 == ' ' Accounting 5 Qox !!!! DX Delete Paste BI U V Sensitivity E O $ - % 9 Conditional Format as Cell Formatting Table Styles Format Sort & Find & Filter Select Analyze Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity E3 X for A E F. . 1 J K L M N o Q 1 Bonus Paid Day 2 3 Sun 4 Sun 5 Mon 6 Mon 7 Tue 8 Tue 9 Wed 10 Wed 11 Thu 12 ThU 13 Fri 14 Fri 15 Sat 16 Sat 17 18 19 20 21 B Week of October 19 Supervisor Shift Sales on Duty Afternoon Janice $ 1,212 Evening Sunny $ 1,256 Afternnon Alissa $ 986 Evening Quynh $ 972 Afternoon Alissa $ 994 Evening Janice $ 1,387 Afternoon Sunny $ 1,047 Evening Quynh $ 1,108 Afternoon Alissa $ 1,389 Evening Seo-yeon $ 1,289 Afternoon Sunny $ 1,347 Evening Seo-yeon $ 1,156 Afternoon Alissa $ 1,876 Evening Janice $ 1,877 Scenario Summary Smoothie Costs Weekly Sales Supervisor Awards Display the Supervisor Awards worksheet. Supervisors earn a bonus based on the Sales during their shift. In cell E3, enter an IFS function to compute a bonus based on the following: Sales over $1,200 earn a bonus of $75, Sales over $1,100 earn a bonus of $50, Sales over $1,000 earn a bonus of $25, and if conditions are not met, leave the cell blank. Copy the formula down through cell E16. Eleven bonuses display as the result. File Home Insert Insert Draw Home Page Layout Formulas Data Review View Developer Help B Share Comme Insert Century Gothic v11 == ' ' Accounting 5 Qox !!!! DX Delete Paste BI U V Sensitivity E O $ - % 9 Conditional Format as Cell Formatting Table Styles Format Sort & Find & Filter Select Analyze Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity E3 X for A E F. . 1 J K L M N o Q 1 Bonus Paid Day 2 3 Sun 4 Sun 5 Mon 6 Mon 7 Tue 8 Tue 9 Wed 10 Wed 11 Thu 12 ThU 13 Fri 14 Fri 15 Sat 16 Sat 17 18 19 20 21 B Week of October 19 Supervisor Shift Sales on Duty Afternoon Janice $ 1,212 Evening Sunny $ 1,256 Afternnon Alissa $ 986 Evening Quynh $ 972 Afternoon Alissa $ 994 Evening Janice $ 1,387 Afternoon Sunny $ 1,047 Evening Quynh $ 1,108 Afternoon Alissa $ 1,389 Evening Seo-yeon $ 1,289 Afternoon Sunny $ 1,347 Evening Seo-yeon $ 1,156 Afternoon Alissa $ 1,876 Evening Janice $ 1,877 Scenario Summary Smoothie Costs Weekly Sales Supervisor Awards Display the Supervisor Awards worksheet. Supervisors earn a bonus based on the Sales during their shift. In cell E3, enter an IFS function to compute a bonus based on the following: Sales over $1,200 earn a bonus of $75, Sales over $1,100 earn a bonus of $50, Sales over $1,000 earn a bonus of $25, and if conditions are not met, leave the cell blank. Copy the formula down through cell E16. Eleven bonuses display as the result
