Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi, I'm trying to come up with the formula for excel that will help me with this exercise: Enter a logical function in cell F5
Hi, I'm trying to come up with the formula for excel that will help me with this exercise: 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. The FT/PT is in column B, Dependents on C, Salary in D, Deductions in E.
Can you help me to get the formula I would use?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started