The company has a 401K program. If an employee has worked for the company 2 years or more they have their annual salary time the match in R19.

Put a formula in M14:M113 that calculates the value of the 401 contribution based on columns K and I and the value in R19. If any of the values change

the formula needs to still work correctly.

Put a formula in N14:N113 that caluclates the employees bonus values based on the values in R14:R113 and the and ranges in Q14:Q17.

Put a formula in O14:O113 to dispalay Health Cost by taking the employees selection in column J for a health plan and looks up the Monthly Premium in V24:V26

based on the name in U24:U26 matching the value in column J.

All formulas must use absolute references as appropriate.

I need help with all the questions please.

Transcribed image text