Excel ready cells showing error or formula 



Good Morning, ,

Today is Saturday, June 13
It has been a long time since there was any donation 
towards the cost of the Humor Letter.
I don't think everybody lost interest. I doubt that 
you all are even more broke than I am. 
I asked a friend what the problem might be. She told
me that I didn not ask for help right out front.
So I did. She promptly dumped her coins into my hand.

Luckily here in Canada we have gotten rid of $1 and $2
bills and replaced them with $1 and $2 coins quite some
time ago, and nowadays an average wallet's load of coins 
is about seven dollars. I sure gave her a grateful hug!

If you can spare some coins, please send them to me!
Or use PayPal.

If you can help with the cost of the Humor Letter, please donate what you can!
Have FUN! DearWebby ______________________________________________________ Today's Bonehead Award goes to a Florida man, who abducted neighbor for being loud in their own laundry room. Details at Boneheads Today in 1789 Ice cream was served to General George Washington by Mrs. Alexander Hamilton. More of what happened on this day in history at History ______________________________________________________ He who asks is a fool for five minutes, but he who does not ask remains a fool forever. --- Chinese Proverb Too often we... enjoy the comfort of opinion without the discomfort of thought. --- John F. Kennedy ______________________________________________________ Several months after a young man is hired, he is called into the personnel director's office. "What is the meaning of this?" the director asks. "When you applied for this job, you told us you had five years of experience. Now we discovered this is the first job you've ever held." "Well," the young man replies, "in your advertisement you said you wanted somebody with imagination, and since it was your accounting department who found out, and not my foreman, I would say that was good enough." ______________________________________________________ Two highway patrolmen stop a driver for speeding on the state highway in Waxahachie, Texas. As they are writing up the ticket, one trooper turns to the other and asks, "How do you spell Waxahachie?" The other one replies, "I don't know." "What are we going to do?" the first one asks. "If we spell it wrong, the judge will dismiss the charge." "Well," says his partner, "why don't we just let him go and stop him again when he gets to Waco?" ______________________________________________________ Click through for the big picture Grein, Austria gets lots of rain now and then.
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 has been earned by Leon Thurston, 61, Vero Beach, Floriduh
Florida man abducted neighbor for being loud in laundry room You're supposed to love thy neighbor, not kidnap them -- no matter how loud they are in the laundry room. Leon Thurston, 61, of Vero Beach, Florida, faces kidnapping charges after police say he abducted a neighbor at gunpoint early Sunday morning because he felt she was making too much noise while washing her clothes, according to WESH TV. Jessica and David Scoville were washing clothes in their laundry room at about 5:30 a.m. when Thurston, their next-door neighbor, appeared in the doorway and said they were being too loud. Thurston was carrying a handgun and a baton. He allegedly hit David Scoville with the baton twice before grabbing Jessica Scoville by the wrist and taking her from her home, according to WPBF TV. Police were called to the scene and used a K-9 unit to track Thurston and his alleged victim. Investigators were not able to find the pair, but Jessica Scoville later escaped after telling Thurston she needed to use a bathroom. She fled and flagged down police officers. The victim told police that Thurston took her to a nearby park and made her walk around a dirt track for a few hours while they spoke, WPTV reports. Officers arrested Thurston and found a .22-caliber Derringer in his front pants pocket. Police said Thurston copped to the crime. “He stated that he walked around with her and spoke to her to ‘blow off some steam,’" according a police report obtained by TCPalm.com. "He advised he was not going to hurt her,” but wouldn't let her leave because he wasn't done talking to her. Thurston also told officers, “He wished he hadn’t done what he did.” The suspect was charged with armed burglary, aggravated battery and assault, kidnapping, false imprisonment and carrying a concealed firearm. In addition, he is suspected of stealing a bathing suit left on a clothesline on Saturday, according to WPTV.com. He is currently in the Indian River County Jail.
______________________________________________________ Tech Support Pits From: Ed Re: Excel ready cells showing error or formula Dear Webby When I set up a spreadsheet where I will enter numbers later, the formulas, that will calculate those numbers either show or have an ugly error until I enter the numbers used by those formulas. I have seen screen shots of your spreadsheets in the 90's, and they never have those ugly #Value! errors. How do you fix that? Ed Dear Ed I use a simple IF formula to test, if someting is in the input cell. Let's say cell E3 has to multiply whatever you are going to put into B3 with what is in H3 =IF(B3<>"",B3*H3,"") If we read that out loud, it would be IF B3 IS NOT nothing, then multiply what is in B3 with what is in H3, ELSE, if nothing is in B3, show nothing in E3 <> is the sign for IS NOT "" is the sign for NOTHING The way the IF formula works is IF (cell questioned, if answer is TRUE then do this, ELSE if answer is not true, then do that.) That <>"" trick is a handy part of many formulas to get clean and neat spreadsheets. They don't tell you that in college, because I guess the professor wants to see the formulas. In real life we prefer to just see the results, if there are any. Have FUN! DearWebby _____________________________________________________ ______________________________________________________ ====From Lorna Hi Webby, a few years ago you had a phantastic piece about a Hawaian Good Luck sign and a bumper sticker. Could you please run that one again ? Thanks, Lorna==== Sure, Lorna. It's a bit long, but well worth it. Got a letter from Grandma the other day--this is what it said: The other day I went into a local Christian bookstore and saw a "Honk if you love Jesus" bumper sticker. Well, I was feeling particularly sassy that day because I had just come from a thrilling choir practice and a thunderous prayer meeting, so I bought the sticker and put it on my car. Boy, I'm glad I did! What an uplifting experience followed! I was stopped at a red light at a busy intersection, just lost in thought about the Lord and how good He is, and I didn't notice that the light had changed. It's a good thing someone else loves Jesus because if he hadn't honked, I'd never have noticed. Then I found that LOTS of people love Jesus! Why, while I was sitting there, the guy behind me started honking like crazy, leaned out his window and hollered, "For the love of God! Go! Go! Jesus Christ! Go!" What an exuberant cheerleader for the Lord he was! Everyone started honking! I just leaned out my window and started waving and smiling at all those loving people. I even honked my horn a few times to share in the love. There must have been a man from Florida back there because I heard him say something about a "sunny beach." I saw another guy waving in a funny way with only his middle finger stuck up in the air, so I asked my teenage grandson in the back seat what that meant. He said it was probably a Hawaiian good luck sign or something. Well, I've never met anyone from Hawaii, so I leaned out the window and gave him the good luck sign back. My grandson burst out laughing--even he was enjoying this religious experience! A couple people were so caught up in the moment that they got out of their cars and started walking toward me. I bet they wanted to pray or ask me what church I attended, but I noticed that the light had changed. So I waved to all my sisters and brothers grinning and drove on through the intersection. I noticed that I was the only car that got through before the light changed again and felt kind of sad to leave all those people behind after the love we'd shared, so I slowed down, leaned out the window and gave them all the Hawaiian good luck sign one last time as I drove away. ______________________________________________________ "Mr. Clark, I'm afraid I have bad news," the doctor told his anxious patient. "You only have six months to live." The man sat in stunned silence for the next several minutes. Regaining his composure, he apologetically told his physician that he had no medical insurance. "I can't possibly pay you in that time." "Okay," the doctor said, "let's make it nine months." _________________________________ If you can help with the cost of the Humor Letter, please donate what you can! ______________________________________________________ Daily tip from Thriftyfun.com Shoe Brush to Paint Cinder Blocks Painting a cinder block breeze brick wall is a long laborious task; with aching back, arms and hands. Trying to get the paint worked into into the rough blocks, I kept thinking there has to be an easier way. There is! I used a shoe shine brush. It was so easy and quick. Lather on the paint with a regular paint brush, a roller is too messy. Paint about two foot square at a time. Use the shoe brush to work the paint into the wall, the short bristles go into the holes in the blocks, saving the effort of going over and over the wall with a paint brush to fill up the gaps. I hope this works as well for everyone else as it did for me. Source: my own By Mary H. [6] ______________________________________________________
Ophelia Dingbatter's News
No sermon 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 woman was in the habit of having long telephone conversations that sometimes lasted over an hour. One day she hung up after 25 minutes. "What is the matter?" asked her husband. "You were on the phone talking for less than half an hour." "I got a wrong number," the woman replied. _____________________________________________________ Brenda's 6 year old was explaining to the other kids what "extinct" meant: "Well," she said in all seriousness, "it means that the dinosaurs are all dead and have been dead so long they don't stink anymore, that's why they call them exstinkt." ____________________________________________________
How awesome is this to find under the earth in your field and not know who built it, when it was built and what it was used for!

Today in 
Today in 
1415 Henry the Navigator, the prince of Portugal, embarked 
 on an expedition to Africa. 
1777 The Marquis de Lafayette arrived in the American colonies 
 to help with their rebellion against the British. 
1789 Ice cream was served to General George Washington 
 by Mrs. Alexander Hamilton. 
1825 Walter Hunt patented the safety pin. Hunt then then sold 
 the rights for $400. 
1898 The Canadian Yukon Territory was organized. 
1900 China's Boxer Rebellion against foreigners and Chinese 
 Christians erupted into violence. 
1912 Captain Albert Berry made the first successful parachute 
 jump from an airplane in Jefferson, Mississippi. 
1920 The U.S. Post Office Department ruled that children may 
 not be sent by parcel post. 
1923 The French set a trade barrier between the occupied Ruhr 
 and the rest of Germany. 
1940 Paris was evacuated before the German advance on the city. 
1943 German spies landed on Long Island, New York. They were 
 soon captured. 
1944 Germany launched 10 of its new V1 rockets against Britain 
 from a position near the Channel coast. Of the 10 rockets 
 only 5 landed in Britain and only one managed to kill 
 (6 people in London). 
1944 Marvin Camras patented the wire recorder. 
1949 Bao Dai entered Saigon to rule Vietnam. He had been 
 installed by the French. 
1951 U.N. troops seized Pyongyang, North Korea. 
1966 The landmark "Miranda v. Arizona" decision was issued 
 by the U.S. Supreme Court. The decision ruled that criminal 
 suspects had to be informed of their constitutional rights 
 before being questioned by police. 
1971 The New York Times began publishing the "Pentagon Papers". 
 The articles were a secret study of America's involvement 
 in Vietnam. 
1978 Israelis withdrew the last of their invading forces 
 from Lebanon. 
1979 Sioux Indians were awarded $105 million in compensation 
 for the U.S. seizure in 1877 of their Black Hills in 
 South Dakota. 
1983 The unmanned U.S. space probe Pioneer 10 became the 
 first spacecraft to leave the solar system. It was launched 
 in March 1972. The first up-close images of the planet Jupiter 
 were provided by Pioneer 10. 
1988 The Liggett Group, a cigarette manufacturer, was found 
 liable for a lung-cancer death. They were, however, found 
 innocent by the federal jury of misrepresenting the risks 
 of smoking. 
1994 A jury in Anchorage, Alaska, found Exxon Corp. and 
 Captain Joseph Hazelwood to be reckless in the Exxon Valdez 
 oil spill. 
1995 France announced that they would conduct eight more 
 nuclear tests in the South Pacific. 
2000 In Pyongyang, North Korea's leader Kim Jong Il welcomed 
 South Korea's President Kim Dae for a three-day summit. It 
 was the first such meeting between the leaders of North and 
 South Korea. 
2015  smiled.


[ view entry ] ( 11 views )   |  permalink  |  print article  |   ( 2.9 / 140 )

<<First <Back | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | Next> Last>>