Thread: Excel Whizz Kids - Help Needed
View Single Post
  #10 (permalink)  
Old 02-12-04, 09:30 AM
Bob Cooper's Avatar
Bob Cooper Bob Cooper is offline
Senior Member
  

Join Date: Oct 2002
Location: Bromley, SE London
Posts: 1,187
Bob Cooper paddles in the seaBob Cooper paddles in the seaBob Cooper paddles in the seaBob Cooper paddles in the seaBob Cooper paddles in the seaBob Cooper paddles in the seaBob Cooper paddles in the seaBob Cooper paddles in the seaBob Cooper paddles in the seaBob Cooper paddles in the seaBob Cooper paddles in the sea
Quote:
Originally Posted by Zdu
So, say in cloumn A I have a list of German words. In column B I want her to type the English translation and be told if that's right or wrong. I'm assuming I'll need a hidden column with the English answers.
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote