LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 159
Default bedroom requirement

I've had no input on this one for about 6 weeks, so I'm resurrecting
it - & it's slightly different. This formula will form part of a
Housing Benefit calculation. There's a figure used in the benefit
calculation (unimportant here) which is based on the bedroom
requirement of the household. I want the bedroom requirement.

The worksheet will have the age of the first parent in C5, the age of
the second parent (if they exist) in D5, the ages of the 4 children in
E5 to H5 and the sex of the children (m or f) in E6 to H6. Other non-
family memebers who may live in the household will have ages in J5 to
M5 and sex in J6 to M6 - they could be any age.

Bedroom requirement:

1 bedroom for:
- every adult couple
- any other adult aged 16 or over
- any two children of the same sex aged under 16
- any two children regardless of sex aged under 10
- any other child


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bedroom Requirement robzrob Excel Worksheet Functions 8 June 29th 08 07:32 PM
Critical requirement. Christopher Naveen[_2_] Excel Worksheet Functions 3 June 22nd 08 01:19 PM
formula requirement pcor New Users to Excel 6 January 7th 06 10:47 PM
Requirement in Bar chart rajeshkumar Charts and Charting in Excel 0 November 9th 05 05:29 PM
my bedroom Chaos New Users to Excel 3 June 27th 05 03:36 PM


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"