Im busy putting together a questioniare and I would like the have an
output of correct or wrong when ever the user entered an answer the
question? Any idea on how to do this?
You mean a test or exam rather than a questionaire?
You'd need to store the expected, presumably correct answer somewhere else,
maybe even in the formula that would give the correct/wrong indication. Let's
say you had the question "Who is buried in Grant's Tomb?" in B2 with D2 as the
answer entry cell. You could use the following formula in cell E2 to display
"Correct" if the correct answer is given, "Wrong" if a wrong answer is given, or
"" if the question hasn't yet been answered.
=IF(TRIM(D2)="","",IF(OR(TRIM(D2)={"Grant","U.S. Grant","U. S. Grant","U S
Grant","Ulysses S. Grant","Ulysses Simpson Grant","Sam Grant","Hyram Ulysses
Grant"}),"Correct","Wrong"))
