If this applies, as an added precaution, you might want to use Data
Validation to limit the choices of what can be entered in cell Q2 to 1 to 6
(right now you have 6 choices) or whatever highest number applies. Depending
on your preference or personality, this might be totally unnecessary.

Since CHOOSE only uses values from 1 to 254, it seems the number 0 shouldn't
be included among your choices.

" wrote:

It's working. There was an extra space in the cells.


Thanks everyone for your help.


On Dec 5, 12:18 pm, Harlan Grove wrote:
wrote...
This is exactly what my formula looks like:

=IF(Q2=0,"",CHOOSE(Q2,"Weekly","Monthly","Quarter ly",
"Every Four Months","Semi Annually","Annually"))

Q2 is the field in my worksheet that I'm referencing to.

...

Try changing this to

=IF(N(Q2)=0,"",CHOOSE(Q2,"Weekly","Monthly","Quart erly",
"Every Four Months","Semi Annually","Annually"))