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

Report
-
Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
-
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
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
213
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
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
213
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