Question: What is the formula? Use a VLOOKUP function in cell F25 of the CatastropheCoverageLowActivity worksheet to determine the appropriate Copayment for the first visit to

What is the formula? Use a VLOOKUP function in cell F25 of the CatastropheCoverageLowActivity worksheet to determine the appropriate Copayment for the first visit to a Primary Doctor. The Type in cell D25 is one of the parameters. Use absolute and relative references when appropriate

What is the formula? Use a VLOOKUP function in cell F25 of

UnitedHealthcare Catastrophic Compass Plus 6600 Single Adult Age 22 -Monthly prenium $160-Deductible $6,600-0ut-ol-pocket maximum $6,600 Copayment Primary doctor-$50 Copayment Specialist Dactor $100 Ernergency Room No charge after deductible Hospital Services No charge after deductible Lab Services No chargeafter doductible Assignment Tasks Health Insurance Monthly premium Maximum out-ofpocket 5 160 6,500 Use a VLOOKUP function in cell F25 of the CatastrophrCoveragclowActivity worksheet to determine the appropriate Copayment for the first visit to a Primary Doctor. The "Type" in cell D25 is one of the 12 13 14 1 Type Deductible Co-Pay arameters. Use absolute and relative references when a rlate [1 Primary doctor Other doctors Emergency ropm 16 17 C $ 6,600$ 19 Total Premium Expense Total Medical Payments 21 al Medical Cost Cost after limit to MAX out of Potential Cost M 23 24 25 26 27 28 Descriptian Type Amount Capayment Deductible Coinsurance to Insured January Primary Doctor Emergency Room & Lab tests Dermatologist officevisit Primary Doctor Uralogist office visit Primary Doctor Eye Doctor exam Primary Doctor Physical Therapist affice visit G24 C $ 1,707 $ 366 B $545 B S175 B 250 April 31 August Drcembe Primary Doctor Totals 37 38

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 Databases Questions!