determine the bonus computed at 5% of the sales of the quarter with the largest sales if the store is in the East territory and if the sales of either quarter are greater than $20,000. You will likely need to use some combination of IF, AND, OR.

Posted: September 11th, 2023

Assignment 2:
Using logical operators AND, OR, NOT, IF, etc., work through each of the 4 problems found in this sheet.Assignment 2 – Excel 46B.xlsx Download Assignment 2 – Excel 46B.xlsx
In problems 1,2,3,try to complete the problems using IF statements, only. In problems 1a, 2a, 3a, try to complete the problems using AND/OR logicals. You may need to combine them, give it a shot!
For questions regarding the bonus, let’s assume: a 5% bonus on average sales if the store is in the East territory.
For question 4, determine the bonus computed at 5% of the sales of the quarter with the largest sales if the store is in the East territory and if the sales of either quarter are greater than $20,000. You will likely need to use some combination of IF, AND, OR.
Generally, think about this like a puzzle, and solve small portions of the larger problem. Good luck!