Question: Using the data below please anwser all the questions below. Please show the forumla used in excel!! Thank you and the fast I get this
Using the data below please anwser all the questions below. Please show the forumla used in excel!! Thank you and the fast I get this the better! I will give thumbs up.

| Guest | Corporatation | Room Type | Cost | Nights Stayed |
| M Choi | Acme | King | 284 | 4 |
| J Bond | United Inc. | Deluxe | 435 | 9 |
| S Sheldon | MGM | Queen | 215 | 2 |
| G Jones | SPS Inc | Queen | 225 | 13 |
| R Greene | Range Inc | Suite | 335 | 4 |
| T Bingham | Range Inc | King | 284 | 1 |
| B Wilfong | ITO Inc | Queen | 215 | 2 |
| P Dolan | WWH Inc | King | 284 | 3 |
| L Patel | SPS Inc | Dsuite | 525 | 5 |
| M Hall | OPM Inc | Deluxe | 435 | 6 |
| J Hoffmann | Talent Inc | QSuite | 305 | 8 |
| E Blech | Standard | 175 | 14 | |
| L Gleason | Queen | 215 | 2 | |
| C. Torger | King | 305 | 4 | |
| K Hough | DriveIT Inc | Deluxe | 475 | 7 |
| E Betof | Goody Inc | QSuite | 325 | 8 |
| F Feldman | Leading Inc | Suite | 350 | 8 |
| M Small | Charm Inc | Queen | 250 | 10 |
1) Classify the nights stayed as Good if the nights are from 0-9 Better Better if the nights are from 10-12 Best Best if nights are 13 or over A) Classify the nights stayed using a NestedIF in Column F B) Classify the nights stayed using a Vlookup with an approximate match in Column G Be sure to build you table array for the Vlookup appropriately. 2) Name your Table Array "Classification" 3) In column H, create a simple IF formula to determine if the Room Type is a King. Show the word "King" if a King, otherwise show nothing
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
