CELL = YES or Other text return value [Solved/Closed]

Report
-
Posts
1269
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 4, 2021
-
Hello,


I'm using IF statements to return a value for the specifc answer supplied for the question and then adding up all the questions for the total score.

A few of the questions are yes, no, NA.

I want to return a 5 for yes and 0 for NA or no.

I'm using =IF(B12="YES",5,0) but it's not returning a "5" when "YES".

Thank you for your help.

2 replies

Posts
1269
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 4, 2021
214
Hello Jason,

I have just tested your formula half a dozen times and it works just fine. I can't see why it wouldn't work.

Cheerio,
vcoolio.
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
1269
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 4, 2021
214
Hello again Jason,

Just an after thought. Have you, per chance, placed the formula in B12? If you have, you should receive a "circular reference" warning and if you continue, the result will always be zero. Hence, move the formula to a different cell and refer to B12 from there.

Cheerio,
vcoolio.
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!