Enter a logical function in cell F5 that calculates employee FICA withholding. If the employee is full-time and has at least one

Question

3 years ago

12

Enter a logical function in cell F5 that calculates employee FICA withholding. If the employee is full-time and has at least one

dependent, then he or she pays 7% of the annual salary minus any deductions. All other employees pay 5% of the annual salary minus any deductions. Copy the function down through column F. Format the data in column F with Accounting Number Format.

Business

1 answer:

mixer [17] · Answer 1 · 2022-02-05T23:01:28+03:00

mixer [17]3 years ago

3 0

Answer:

the formula in cell F5 =IF(AND(B5="FT",C5>0),0.07*(D5-E5),0.05*(D5-E5))

Explanation

Check attachment for the given data and solution data