I am doing a reference of 1, 2, or 3 returning specific text based on the
number. Here is my formula.

=IF(G29=1,"DOES NOT MEET",IF(G29=2,"CONSISTENTLY MEETS",IF(G29=3,"EXCEEDS")))

if the ratings are all 3's the correct text value will appear. If you vary
the ratings I receive a false value. Can anyone help me.