Excel

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)