How do i put an if formula on a Checkbox?

[Xerox]

Hi, I am doing a questionairre and I want to Put a response next to the tick box commenting on their answer. At the momment when i click on the checkbox it says either true or false. I want to change True or false to say my own comments.

I thought an IF statement might work so i put...

=IF(C10=TRUE,"Your favourite music genre is Rap.")

but it didnt work. Hope that made sense and any help would be much appreciated.

 

[jim may]

=IF(C10=TRUE,"Your favourite music genre is Rap.")

Change TRUE to TRUE()

 

[Xerox]

Jim, thanks very much for your suggestion. I tryed it and it didnt work. When you click on the checkbox it just comes up with true or false. Any ideas?

 

[Xerox]

Jim,
Thanks very much for your help.
Ive got it working now.