I am trying to create a simple form for our members to use to register for trips. It includes the normal name, address, and some general fees. However, it is calculating the room/travel charges that is getting to me.

I have attached a sample spreadsheet. I am not certain the best way to create this thing. I need to keep it as simple as possible and to get it out to as many Excel versions out there it needs to be saved in xls.

Basically it goes like this:

There is a membership oriented fee. One price for upper level members and one for the other level. One or the other has to be picked. There is a fee for attending an optional class. These I can easily determine.

Room and travel go something like this.

Rate for double occupancy room
Rate for third person in same room
Rate for child 2-11
Free for child under 2
If only one person in room single supplement

Some of the conditions in past trips have been: Only 3 people to a room. Sometime requires adult with children in room, other times children can have room to own. If more than two people there might be on in own room that needs to be charged single suppl. Sometimes there is a deposit made before the whole trip is put in place and needs to be deducted. Sometimes there is a deductible for people who get their own flight to destination when not meeting up with group and one central airport. These are all International trips.

I then put this total the other fees and/or deductions. I will show two totals. One if paying by check and other with a fee if paying by credit card.

Attached is a sample of what I considered as a start, but if someone can think of a better layout to make the calculations easier let me know.

David
group trip sample.xlsx