Previous Topic Next Topic

CELL = YES or Other text return value

Solved/Closed
Jason - Feb 11, 2016 at 02:15 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Feb 12, 2016 at 04:07 AM
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.
Related:

2 responses

Answer 1 / 2
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 262
Feb 12, 2016 at 03:58 AM
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
Answer 2 / 2
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 262
Feb 12, 2016 at 04:07 AM
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

Similar discussions

Excel function question
1234ah -
ac3mark -

3 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Excel: If Date =, then enter a value
JerrySD -
BrianGreen -

4 responses