Yorkshire Divers

Deep Blue Technical
Go Back   YD Scuba Diving Forums > Non-Diving Related Forums > Technology
Excel Whizz Kids - Help Needed Excel Whizz Kids - Help Needed
User Name
Password

Welcome to the YD Scuba forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

Technology: Discuss Excel Whizz Kids - Help Needed in the Non-Diving Related Forums forums: If you use this formula....... =IF(A1=B1,"correct","wrong") Then if the word typed in ...

Reply
Page 2 of 2 < 1 2
 
LinkBack Thread Tools Display Modes
  #11 (permalink)  
Old 02-12-04, 10:59 AM
Andy the Coastie's Avatar
Andy the Coastie Andy the Coastie is offline
1/411 th of TEAM SAFETY
  

Join Date: Jan 2003
Location: Deal on the Kent coast - Op's room Dover
Posts: 6,389
Andy the Coastie is a scuba diver - cold waterAndy the Coastie is a scuba diver - cold waterAndy the Coastie is a scuba diver - cold waterAndy the Coastie is a scuba diver - cold waterAndy the Coastie is a scuba diver - cold waterAndy the Coastie is a scuba diver - cold waterAndy the Coastie is a scuba diver - cold waterAndy the Coastie is a scuba diver - cold waterAndy the Coastie is a scuba diver - cold waterAndy the Coastie is a scuba diver - cold waterAndy the Coastie is a scuba diver - cold water
Quote:
Originally Posted by Bob Cooper
If you use this formula.......

=IF(A1=B1,"correct","wrong")

Then if the word typed in cell B1 matches the word in cell A1 (which could be hidden) then the word "correct" appears in the formula cell. If not, the word "wrong" appears.

Does that help?

Bob
Then you could go

=IF( C1="Correct",0,1) That will give your daughter a final score.


I do the same sort of thing for my boys , normally little maths tests & seamanship questions
__________________
....Dover Coastguard, CNIS Rules....Dover Sea Cadets....
Dover Sea Cadets - Best Drill squad in the District


You don’t need to be good at swimming to save lives.

OBVIOUSLY YOUR STUPIDITY IS ONLY MATCHED BY YOUR INCOMPETENCE.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply
Page 2 of 2 < 1 2

« IT / Techies / Interweb | Genealogy software - advice please? »

Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



Sponsored Links

Yorkshire Divers - RSS Feed
All times are GMT +1. The time now is 12:32 AM.
Powered by vBulletin
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.0.0 RC6
Trademark and all rights reserved : © YD.com Ltd (2006)
YD.com Ltd (Registered in England - 05886696)
Other sites : Golf Clubs | New Premiership Football Kits | MP3 Portable Players | MP3 Players For Sale | Replica Football Kits

Advertise - Contact Us - Yorkshire Divers - Sitemap - Privacy Statement - Terms & Conditions - Top
Forums Directory