Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions