You could enter the following headings in Row 1:

A B C D
E
Traveler Room Rate Room Tax Days in Room Totals

The following entries in Row 2 (assume interest rate is 12%):

Helen $15 =B2*12% 2 =(B2+C2)* D2

Copy the formulas in column C through E down as many rows as you need.

If you include other travelers in rows 3 and down, you can later sort by
traveler and get subtotals by using Data Subtotals feature.



"lilbit" wrote:

I need to make up a spreadsheet for travelling. It has to include room rate,
room tax, and total cost of room for each traveller.