Steph wrote:
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.


Hi Steph,

I'm not sure to have well understood, but try this:

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

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy