using control form checkbox in excel

[lezawang]

Hi
I want to ask a question to the user and give 3 choices answers.

Q) What is the color of the sky?

[x] blue
[] red
[] green

C1 = correct

If user click on Blue then C1 will show correct. So I linked the first checkbox to B1 and I wrote in C1 the following

=if(B1=true, "Correct", " wrong")

I can do this, but my question, how can I do the reset. I mean if user click on Red or Green, I want C1 show "Wrong"

I am thinking of 3 If(). Do you have better idea? Thank you so much.

 

[Fluff]

Why not use option buttons instead?
That way you check if B1 is 1, 2 or 3