View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
robzrob robzrob is offline
external usenet poster
 
Posts: 159
Default Bedroom Requirement

On Jun 24, 2:40*am, Ron Rosenfeld wrote:
On Mon, 23 Jun 2008 16:29:00 -0700, Dave
wrote:

Hi,
Does it work for 1 boy over 10 and 3 boys under 10?
I understood from your criteria that this would require 3 rooms:-
1 for the couple, 1 for 2 boys under 10, 1 for the under 10 boy and under 16
boy.
Have I misunderstood?
Dave.


On re-reading the post, I believe your interpretation is correct, and that my
solution will not work for that case.
--ron


Hello Ron & Dave

No it doesn't work for that combination - it gives 5, not 3. And it
gives 2 for 2 girls under 10, but 3 for 2 boys under 10!