Report

CELL = YES or Other text return value [Solved]

Ask a question Jason - Last answered on Feb 12, 2016 04:07AM by vcoolio
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.
See more 
Helpful
+2
moins plus
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.
Leave a comment
Helpful
+2
moins plus
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.
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!