Thread: Excel Whizz Kids - Help Needed
View Single Post
  #6 (permalink)  
Old 02-12-04, 09:20 AM
Hoppy's Avatar
Hoppy Hoppy is offline
Member
  

Join Date: Nov 2004
Location: Midlands UK
Posts: 343
Hoppy dips toes in sea annuallyHoppy dips toes in sea annuallyHoppy dips toes in sea annuallyHoppy dips toes in sea annuallyHoppy dips toes in sea annuallyHoppy dips toes in sea annuallyHoppy dips toes in sea annuallyHoppy dips toes in sea annuallyHoppy dips toes in sea annuallyHoppy dips toes in sea annuallyHoppy dips toes in sea annually
Quote:
Originally Posted by Zdu
OK, what I'm trying to is create an excel German translation test for my niece. Duel purpose of spelling and IT introduction.

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.
do it like colin said

so it would go cell A1 Morgen cell b1 (she types the answer) cell C1 would be =IF(B1=Morning,"Correct","Wrong")

Hows that ?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote