Share via

This formula returns FALSE. What is wrong here?

Anonymous
2024-08-08T02:38:13+00:00

=IF(C7="","",IF(C7=4,"Youre on Track",IF(C7=3,"Getting Closer",IF(C7=2,"Keep Trying",IF(C7=1,"Lets Talk About This")))))

Microsoft 365 and Office | Excel | For education | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2024-08-08T15:20:19+00:00

Hi,

Maybe cell C7 is formatted as text. If so, then change the cell format to General or Number or transform your formula by placing double negative (--) signs before C7. So in this case your formula would look like this below:

=IF(--C7="","",IF(--C7=4,"Youre on Track",IF(--C7=3,"Getting Closer",IF(--C7=2,"Keep Trying",IF(--C7=1,"Lets Talk About This")))))

Hope this helps.

Was this answer helpful?

1 person found this answer helpful.
0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-08-08T15:29:38+00:00

    Thank you - That was the problem. It was formatted as text, however in the formula, I did not specify that. This change fixed the issue: As you can see the numbers are now in quotes to indicate that it is text.

    I am teaching myself and it's been fun. I'm glad there is a community to help me! Any other comments are welcome

    =IF(C7="","",IF(C7="4","Wow, You're on Your Way!",IF(C7="3","Keep It Up!",IF(C7="2","You can do it!",IF(C7="1","Can we talk about this?")))))

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-08-08T14:31:29+00:00

    Thank you for replying. I tried this formula and it returns a value of #N/A

    Its strange. I know it is something small.

    Was this answer helpful?

    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  4. Anonymous
    2024-08-08T03:23:19+00:00

    Hi,

    try this

    =IFERROR(LOOKUP(C7,{1,2,3,4},{"Lets Talk About This","Keep Trying","Getting Closer","Youre on Track"}),"")

    Was this answer helpful?

    0 comments