Question: I do believe this is an IF statement formula that is needed, just a bit confused on how to execute it. Looking for some help.

I do believe this is an "IF" statement formula that is needed, just a bit confused on how to execute it. Looking for some help.

The second page is the benefits code. That the prior VLookup formula was created from for E5:G5, but not sure if it is needed!

Here is the question:

"Insert a function in cell H5 to calculate Total Employee Cost for the first customer. If the customer needs daycare, the total cost should include that column amount. If the customer does not need daycare the total cost should not include that column amount."

I do believe this is an "IF" statement formula that is needed,just a bit confused on how to execute it. Looking for some

1 Fireball Technology Corrparny 2 Salary and Bene Expenditures Health Insurance Costs Daycare Costs Tatal Employee Cost Employee Benefits Coe Need Daycare Salary Pension Costs 9775 37150 32500 34000 35650 42500 29900 34000 30450 Yes Yes 10 Yes 12 33000 Yes Yes Yes 15 28600 36000 37300 34000 36500 33000 34000 34500 34000 30000 40000 36000 37000 42850 42000 44000 40650 44000 48500 42000 47500 47000 48500 16 17 13 18 19 15 201 16 21 17 22 18 23 19 24 20 25 21 Yes Yes Yes Yes Yes 26 1-22 27 23 28 24 29 25 30 26 31 27 32 28 33 29 34 30 35 3 36 37 33 Yes Yes Yes Yes 32 34 Yes 52500 39 35 41 37 42 38 43 39 Yes Yes 250 57000 58500 60050 72000 40 Yes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!