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.

Using the data below please anwser all the questions below. Please show

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

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!