Question: I don't know how to do this please help. (1.1) Calculate the number of (1.2) Calculate the Room Total for (1.3) Calculate the Add-On Total

I don't know how to do this please help.

I don't know how to do this please help. (1.1) Calculate the

(1.1) Calculate the number of (1.2) Calculate the "Room Total" for (1.3) Calculate the "Add-On Total" for the first transaction. Rooms with 3 or more guests are required to pay the add-on fee. - Use an IF function with a nested VLOOKUP to calculate the total based on the number of guests, number of nights and the room type. - Use the data in P4:Q6) to look up the cost based on the room type. - The add-on fee is per person per night. - If there is no add-on fee display a zero (0) in the cell. - Copy and paste the function down the column to calculate the addon total for the other transactions. 10 (1.1) Calculate the number of (1.2) Calculate the "Room Total" for (1.3) Calculate the "Add-On Total" for the first transaction. Rooms with 3 or more guests are required to pay the add-on fee. - Use an IF function with a nested VLOOKUP to calculate the total based on the number of guests, number of nights and the room type. - Use the data in P4:Q6) to look up the cost based on the room type. - The add-on fee is per person per night. - If there is no add-on fee display a zero (0) in the cell. - Copy and paste the function down the column to calculate the addon total for the other transactions. 10

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 General Management Questions!

1 . 1 Calculate the number of 1 . 2 Calculate the "Room Total" 1 . 3 Calculate the "Add - On Total" for the first transaction. Rooms with 3 or more guests are required to pay the add - on fee. Use an...

Atlas 3 . 0 remoder the rooms. Ine manager has asked you to complete the "Remodel" worksheet to help him schedule employees for the remodel. 1 . 1 Calculate the number of 1 . 2 Calculate the "Room...

Atlas 3 . 0 remodentne rooms. Ine manager has asked you to complete the "Remodel" worksheet to help him schedule employees for the remodel. 1 . 1 Calculate the number of 1 . 2 Calculate the "Room...

MyEducator Tasks has asked you to complete the "Remodel" worksheet to help him schedule employees for the lue _ if _ false ] ) 1 . 1 Calculate the number of 1 . 2 Calculate the "Room Total" for the...

\ table [ [ 3 , , , the,Audect iotal Total with If ] , [ 3 , 2 , $ 1 5 0 . 0 0 , HNALUE!, ] , [ 2 , 2 , $ 3 2 5 . 0 0 , , ] , [ 8 , 2 , $ 3 0 0 . 0 0 , , ] , [ 2 , 4 , $ 1 5 0 . 0 0 , , ] , [ 6 , 1 ,...

scrieaule empioyees ror the remodel. 1 . 1 Calculate the number of 1 . 2 Calculate the "Room Total" for the first transaction. Use an IF function to calculate a 1 0 % discount for any stay greater...

Hello, I already follow through up to the 5th point but I am confused because of the wordig of this question (I dont think that it is a simple percentage formula what it needs to be done, but some...

(1.1) Calculate the number of nights for the first transaction. - Copy and paste the formula down the column to calculate the nights for the other transactions. 10 (1.2) Calculate the "Rojom Total"...

Atlas 3 . 0 calculations that he can use to help him schedule the cleaning staff for the next month. The Quincy Adams and Truman rooms are the least popular rooms reserved at the Inn. Because of this...

A sample of nitrosyl bromide (NOBr) decomposes according to the equation An equilibrium mixture in a 5.00-L vessel at 100 oC contains 3.22 g of NOBr, 3.08 g of NO, and 4.19 g of Br2. (a) Calculate...

For a receivable on account company received 6 months' note on Nov. 1,2022 with an interest rate of 15%. The amount on the note is 58,000 TL Required: Prepare the journal entry for the following...

CX Enterprises has the following expected dividends: $ 1 . 0 5 in one year, $ 1 . 2 2 in two years, and $ 1 . 3 3 in treee years. Ater that, its dividends are expected to grow at 3 . 7 % per year...

2. The force of interest 8 is a function of time and at any time t, measured in years, is given by the formula: 8(t) = 0.02 +0.0020 8(t) = 0.03 +0.005t Osts5 5 st s 10 a) Calculate the discount...