In cell b17, enter a formula to calculate the amount budgeted for hotel accommodations. this amount is based on the # of nights, the hotel rate/night, and the hotel tax rate. in parentheses add the hotel tax rate to 1 to equal 118% percent before multiplying.

I recently had this assignment and here are a couple of was to do this:

1st way (which is correct according to my grading):

= # of Nights*Hotel rate * (1+hotel tax rate)

2nd way (I got counted wrong for this one on my assignment):

= (hotel rate + (hotel rate*hotel tax rate)) * Number of nights