Project: Excel Level 2 Chapter 2 Project Using named ranges, create a nested IF function in cel F6 that calculates the standard cost using the following guidelines: the room type is private, use Days x Privatecost. If the days in the hospital are less than or equal to 7. use Days * Daily Shoncost. If the days in the hospital are greater than 7. use Days Daily Long Cost. Note: When referring to the room type (private) in the formula, use all lowercase letters. Copy the formula in cel F6 into the range F7 F20 Alta Rem File fx Insert Function Home Insert lasmine Otero Page Layout Formulas Data Review 32 ACS AutoSum Recently Financial Logical Test Date Lookup & M - - Time Reference Trig - FunctionsWe Function Library G Neurology Average Cost Statistics - Excel View Acrobat QuickBooks Tell me what you want to de ene Name. Tace Precedents de Show For Show Formulas Usefom Trace Dependents in Checking to for Section S erver Arrows - Formule Wind Formula Auditing Sale Now L M N O billy Cout long stay $ 1,600 Bob Ohio River General Hospital Division of Neurology Adult Neurology Surgery Average Cost Statistics (All Surgeries) Month November Surgeon Novak Patient Room Dersin standard Payment pilvate bally cost Patient No Last Name Name Type Hospital Cout code cont short stay 60334124 Wagner private $ 2,100 ,100 60114567 Horton 60398754 Verina Paula 60347021 Dowling Jager $ 5.000 60328192 Ashman $ 10,000 60321349 Kaiser Lana private $ 20,000 00398545 Van Bomm Emily 00342541 Youngblood Frank Semi 60331569 Larimar 602471159 Peterson Mark 00158642 Harper Norton 6o150062 lenkins Esther private 68521245 Norfolk Marianne sem 61552158 Adam Wiley Susan sem 68451278 Emerson Kiley private Cart B 12 13 14 16 Total Standard Cost: Project: Excel Level 2 Chapter 2 Project Using named ranges and the AVERAGEFS function in E28 create a semua to calculate the average standard costre room is a semi private room (sem short ( 7 days) Note: When referring to the room type (sem in the formula, use at lowercase letters. and the length of the stays Review Neurology Average Cost Statistics - Excel View Acrobat QuickBooks Otel me what you want to do Deline Name - Trace Precedents of show formula Use in formular Trace Dependents mor Checking .. Create from Selection S omove Anon Evaluate loomade We Do Deine Nam Formula Avatha Home l amine Otero Page Layout Dots fx EBBE A ESO E Iment autotum Recently financial logical Yea Dute to lookup & Motic More unction - Used O Time Reference the lunction Function by - X A VERAGES Standard Cost,2) calculate Manson 13 5033567 Horton 50398754 Verina Paula 60347221 Dowling lager 60321 Ahiman 501211 Kater 60398545 Van Bomm Emily 60343548 Youngblood Frank 6033150 Lori Hannah 602475 Peterson Mark 60158942 Harper Norton 60458962 Jenkins Esther 58521245 Norfolk Marianne 63552158 Adam Wiley Susan 60451278 Emerson Kiley 15 17 private 19 private Average range Criteria tanget Total Standard Cost: Patients Short Stay Patients Long Stay Averate of Private Days Average of Semland Est, 2 evitaron Sum of Private
