Excel Spreadsheet Help
Posted 05 April 2012 - 10:00 PM
I'm doing a spreadsheet for my school and I was wondering how I could give an automatic calculation of the no. of people needed to be seated into each room. So say if there were 6 adults and 1 child going onto the trip; and I had the options of a Double Room, Single Room, and a Triple Room for them to choose from.
How would I put, in a formula... to automatically insert the total number of people into the correct rooms?
I was also wondering if someone could go through "IF" functions for changing a formula already inserted into the spreadsheet into another one.
Posted 06 April 2012 - 09:19 AM
Triples = FLOOR(people/3)
Remainder = MOD(people, 3)
Doubles = IF(Remainder=2, 1, 0)
Singles = IF(Remainder=1, 1, 0)
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users