Question

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.

Answer 1

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