Thread: My IF in Excel formula is not returning the correct value.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steph Steph is offline
external usenet poster
  
Posts: 110
Default My IF in Excel formula is not returning the correct value.
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.
Reply With QuoteReply With Quote