3 In H3, apply a nested function based on the following criteria; if salesperson has worked more than 3 years, their Total Sales are 100,000 or more and they are responsible for Territory Alberta, they will receive a bonus 3.5% salary increase, otherwise they will receive a standard 1.0% salary increase. Reference the percentages in B21:B22. Re vults should show the bonus amount. (4) In I3 use the IFS function to determine the salary plus bonuses. In the function refer to the Sales Positions listed in A18:A20. Each cell in this range is part of the Logical Test Condition and each cell in B18:B20 will be the individual Value if True in the function. These references must also be absolute. Complete the function producing the bonus amount only and confirm that the correct bonuses are displayed. (3) Edit the function in 13 to add both the Conditional Raise from column H and the Salary located in column E. (2)
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
