Hi Folks,
I was wondering if the following puzzle can be put in a formula, with
perhaps IF statements or however one can decide to solve. I was
thinking of a spread sheet where we can focus on 5 cells eg. A1 to A5
and assume each as a house and write formula or code:

Here it goes:

there are five mebn of five different nationalities, living in five
different houses, of five different colors, each with different pet,
cigarette and beverage. The pets are a dog, a camel, a giragge, an
elephant and a horse. The mena re a Scotsman, a Norwegian, a German an
Englishman and an Irishman. The men smoke Camels, Pall Malls, Kools,
Salems and Chesterfields. The colors of the houses fare red, brown,
yellow, blue and green. The beverages are tea, juice, offfee and
water.

1. The Yellow house is immediately to the right of the green house and
has only
one neighbor.
2. Milk is drunk in the middle house.
3. The man in the red house lives immediately to the left of theman
who smokes
Chesterfields.
4. The Norweigian doesn't drink milk.
5. Tea is drunk in the house next to where the Scotsmnan lives.
6. The Scotsman smokes Camels.
7. The Irishman lives immediately to the left of theman who smokes
Pall Malls.
8. The dog lives in the house next to the house where the Irishman
lives.
9. Ther German lives next to the blue house.
10 The Germandrinks coffee.
11. The Giraffe and the elephant lives in houses separated by the blue
house.
12. The man in the green house smokes Salems.
13. The Englishman lives to the right of the house where juice is
drunk.
14. The horse lives in the niddle house.
15. The camel lives next tot he house where Kools are smoked.
16. The Scotsman lives in the brown house.

Now, who drinks tea? Who owns the horse? Name all five things for all
five homes.


Good Luck
Jaz


--
jazbath
------------------------------------------------------------------------
jazbath's Profile: http://www.excelforum.com/member.php...o&userid=29467
View this thread: http://www.excelforum.com/showthread...hreadid=491735