Thank you again Narayan. I actually broke the last formula you sent down into 2 parts. That way I was able to show my instuctor the price increase for the 11 single rooms and for the 13 double rooms.
Narayan what you said is correct. The single rate is 1800.00 each person and the double is 2750.00 each person. I guess I have to figure out the best way to put everything into my spreadsheet. This site is awesome!!! THANK YOU to everyone that's trying to help me for I greatly appreciate your...
How do I write the following formula:
37 people are going on a trip
11 single accomdations is 1800.00
13 double accomdations is 2750.00
If the now of people falls below 30 the single accomdations will cost 2950.00 and the double will cost 2250.00
Thank you