[Indi]

Hi,

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.

[fred]

If there's no other constraints and assuming the goal is to minimise the number of rooms, surely it's just a case of getting as many triples as possible plus one single or double depending on how many people are left over?
Triples = FLOOR(people/3)
Remainder = MOD(people, 3)
Doubles = IF(Remainder=2, 1, 0)
Singles = IF(Remainder=1, 1, 0)

[Indi]

Sounds right, what your saying, but I need to know what those functions do now.
http://puu.sh/occK

...and where do I put them.

This post has been edited by Indi on Friday, Apr 6 2012, 14:04