how would you write this to get a calculation. consider annual salary as A2 and bonus percentage as 2.5%.

H Assignment1-Question.pdf - Adobe Acrobat Reader DC File Edit View Window Help Home Tools Assignment 1-Ques... X Employees are Pay Grade 2, 3, or 4, who has over 3 Year of Service, are in Finance or Marketing department, will receive Bonus. Bonus Annual Salary* Bonus Percentage. Bonus Percentage can be found in Q1-22 Worksheet. If the employee doesn't match the criteria, Bonus will equal to $0. Use Logical functions determines the Bonus. Insert a new column on the left of the Monthly Salary; name the column with the heading as "Bonus". (4 points) Refer to Tutorial 3- Question 14 Hint: First, determine all the criteria. Then use if, and, or functions to join all the criteria together. See the below list for the criteria. 21. Assig Engish ( com com 1. Employee in Pay Grade 2, 3 or 4 2. Year of service greater than 3 3. Finance department 4. Marketing department Reda Pvote Opbin DOLL H Assignment1-Question.pdf - Adobe Acrobat Reader DC File Edit View Window Help Home Tools Assignment 1-Ques... X Employees are Pay Grade 2, 3, or 4, who has over 3 Year of Service, are in Finance or Marketing department, will receive Bonus. Bonus Annual Salary* Bonus Percentage. Bonus Percentage can be found in Q1-22 Worksheet. If the employee doesn't match the criteria, Bonus will equal to $0. Use Logical functions determines the Bonus. Insert a new column on the left of the Monthly Salary; name the column with the heading as "Bonus". (4 points) Refer to Tutorial 3- Question 14 Hint: First, determine all the criteria. Then use if, and, or functions to join all the criteria together. See the below list for the criteria. 21. Assig Engish ( com com 1. Employee in Pay Grade 2, 3 or 4 2. Year of service greater than 3 3. Finance department 4. Marketing department Reda Pvote Opbin DOLL