Can you use "Like"

[Robert Gillard]

I am trying to set up a simple learning aide for my daughter. She has a
large list of words to learn, however some of these words have several
mearnings.
What I wanted to do was to have the word the word in A1, the correct meaning
in a hiden collumn B1, she would then type in C1 what she thought was the
correct meaning. I wanted to use just a simple
=IF(C1=B1, "correct","wrong") in D1
however because some answers have "multiple " meanings how can I set the
formular to accept either answer

A1 B1(hidden) C1 D1
porto perhaps, maybe maybe correct


with thanks

Bob

 

[Bob Phillips]

Bob,

You could try this

=IF(ISNUMBER(FIND(C1,B1)), "correct","wrong")

although the answer 'may' would also give correct.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)