AND function in Excel 



Zoom the font size for best readability
Good Morning,  !
It's Friday, December 10, 2010
Time to wear a bit of red to show your support for the troops!

A reader asked me if I could think of a project, that could 
get her mother motivated out of the funk, she has been in
since dad died. Mother doesn't like traveling, and can't do
crafts in her tiny apartment.

Well, the answer to that is easy! Mother can do a Legacy,
a web site, that chronicles her life. One does not have to 
be famous in order to write an autobiography, and usually
the not famous people had more interesting lives anyway.

She can start like a photo album, and fill in stories as she
thinks about them. And they don't have to be any more
truthful, than the ones in Bill Clinton's biography.

Doing it is as easy as writing an email, the cost is negligible, 
and coaching is included. So, why not? It definitely is
someting one can get excied about, and in the long run
more valuable to descendants than some hand knit socks.

Have FUN!
DearWebby


If you can help with the server cost
please donate what you can!
Women always think they can change their man They never change. Men alway hope that their woman won't change They always change. --- Socrates
A young man volunteered to baby-sit one night so his girlfriend and her mom could go to some tupperware party . At bedtime he sent the youngsters upstairs to bed and settled down to watch football. One child kept creeping down the stairs but the young man kept sending him back. At 9pm, the doorbell rang, it was the next-door neighbour Mrs. Brown, asking whether her son was there. The young man brusquely replied, "No". Just then a little head appeared over the banister and a voice shouted: "I'm here Mom but he won't let me go home."
The Ultimate Guide to Speedy Green Cleaning!
No other product like it. The secrets to saving time, money,
effort and to declutter your life! From cheap, effective home
made cleaning recipes, step-by-step speed cleaning instructions,
and how to declutter and stay decluttered. This book has it all.

If you need a low cost Christmas gift,
that will actually get USED, get Speedy Green Cleaning!

A guy walks into a bar and approaches the barman, "Can I have a pint of Less, please?" "I'm sorry sir," the barman replies, looking slightly puzzled, "I've not come across that one before. Is it a spirit?" "I've no idea," replies the guy, "The thing is, I went to see my doctor last week and he told me that I should drink Less."
Thanks to Lillemor for these pictures: Click through the picture to the large version. Click through the picture to the large version.
If you like the Dear Webby Daily Humor Letter, please vote for it at the Ezine Finder: Thanks for your votes!

An INTERNATIONAL BONEHEAD AWARD goes to John Thomas Nelon Jr., 29, of Vinton, Virginia Meth-maker's proudly displayed GED certificate told cops who ran drug lab A man who hung his GED certificate above his methamphetamine cooking rig, then fled police by taking to the woods with a tent and a bowl of macaroni and cheese, pleaded guilty today to charges that could send him to prison for years. John Thomas Nelon Jr., 29, of Vinton, pleaded guilty in federal court in Roanoke to charges that he manufactured meth and that he did so in the presence of a minor. U.S. District Judge Samuel Wilson ordered a pre-sentencing report. A sentencing date was not immediately available. Nelon made his meth in a garage, where he and his 15-year-old girlfriend also lived, Assistant U.S. Attorney Andrew Bassford said. When an anonymous tip led to a police search in May, officers found meth-making equipment and ingredients. Officers also found Nelonís GED certificate hanging above the gear, leaving little doubt who they were looking for, Bassford said. Neighbors around the garage, located in the 100 block of Vintonís West Madison Avenue, were evacuated as coverall-wearing officers cleared potentially hazardous chemicals from the site. Nelon, having heard about the search, went into hiding in the Bedford County woods, Bassford said. But he took scant provisions and when his girlfriend went to resupply him, officers were watching. Nelon tried to run, but "he did not outrun the police dog," Bassford said. Nelon chuckled at Bassfordís account and told the judge he did not dispute it.
From the Tech Support Pits: From: Britta Re: Excel AND formula Dear Webby, My hubby printed out your letter and work and brought it home, because I do a lot of work with spreadsheets. I love the way you explain things, with the reason and logic, not just the how. Maybe you can explain how to use the AND function in formulas. It just does not make sense to me. Thanks Britta --------------------- Dear Britta The AND function does not stand alone, because it only returns a TRUE or FALSE, not a number. So you nest it inside an IF formula. IF [ (this is true AND that is true), then do ABC, else if not BOTH those tests are true, then do DEF ] And example would be: =IF(AND(B5 > 7, B5 < 10), P2,P3) It is a bit odd, that the AND is at the front, but that is because it has to be outside the bracket, that has the conditions. You can, of course, have more than just two conditions evaluated for true or not true. Only when ALL the conditions inside those re brackets are true, THEN the IF part uses the first choice, whatever is in P2. If any one of the conditons inside the red AND brackets is not true, then the IF uses the second choice, whatever is in P3. Have FUN! DearWebby
Imagic Photo - image and photo enhancement software
Photo enhancement software that transforms ordinary,
drab photos into beautiful images.
YOU can do it with IMAGIC

A college student with a young child was pleased when her daughter became eligible to attend the day care center at the University. The director of the day care gave the mother a tour of the facilities. To assure herself of the center's high standards, the young mother asked about the curriculum. "Well," said the director, eyes twinkling, "today we are studying the children's favorite philosopher: Play-Dough." (Plato was a famous philosopher in Greece about 2400 years ago)
Daily tip from Thriftyfun.com Soak Cooking Raisins in Liquid Whenever a recipe calls for raisins, before adding them, I always soak them in a liquid that goes with the recipe. Praline liqueur or rum for bread pudding, apple or orange juice for cookies, breads, etc. This adds flavor, produces a moister dish and for a few pennies the raisins look so much more extravagant. By Frazzled Leslie from Metairie, LA http://www.thriftyfun.com/ Check out ThriftyFun's Blog at http://www.myfrugallife.com Thriftyfun.com also has a newsletter. If you want more than just one tip per day, or if you want to share your tips, then you can subscribe to it here:ThriftyFun Highly recommended! If you like the ThriftyFun.com list, you can vote for it here:
Lisa was out driving her car and while stopped at a red light, the car just died. It was a busy intersection and the traffic behind her was starting to pile up. The guy in the car directly behind her was honking his horn continuously as Lisa continued trying to get the car started up again. Finally Lisa gets out of her car and approaches the guy in the car behind her. "I can't seem to get my car started," Lisa said, smiling. "Would you be a sweetheart and go and see if you can get it started for me. I'll stay here in your car and honk your horn for you."
Ophelia Dingbatter's News
No sermon here and not suitable for church, just jokes and fun for grownups. Read it on-line or subscribe. If you subscribe, look for the double-opt-in confirmation request.
A good wife sometimes forgives her husband when she's wrong.

Ľ Paper Snow Flakes
Mrs. Jones was reading a letter at breakfast. Suddenly she looked up suspiciously at her husband. "Henry," she said, "I've just received a letter from mother saying she isn't accepting our invitation to come and stay, as we do not appear to want her. What does she mean by that? I told you to write and say that she was to come at her own convenience. You did write, didn't you?" "Er, yes, I did," said the husband. "But I couldn't spell 'convenience,' so I made it 'risk'."





[ view entry ] ( 167 views )   |  permalink  |  print article  |   ( 3 / 45 )

<<First <Back | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | Next> Last>>