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

Question

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

Report

Jason - Feb 11, 2016 at 02:15 PM
vcoolio

Posts: 1260
Registration date: Thursday July 24, 2014
Status: Moderator
Last seen: February 3, 2020

- 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.

If cell contains multiple text then return value
If cell contains any text then return value - Best answers
If yes return value excel - Best answers
If cell contains a date then return text ✓ - Forum - Office Software
If cell contains any text then return value ✓ - Forum - Excel
Excel - IF function with multiple words ✓ - Forum - Excel
If cell contains a certain text, add the numbers of another cell ✓ - Forum - Excel
Excel: If Date =, then enter a value ✓ - Forum - Excel

2 replies

Answer 2 / 2

vcoolio

Posts: 1260
Registration date: Thursday July 24, 2014
Status: Moderator
Last seen: February 3, 2020

213
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.

Ask a question

vcoolio · Accepted Answer · 2016-02-12T03:58:53-0500

Answer 1 / 2

vcoolio

Posts: 1260
Registration date: Thursday July 24, 2014
Status: Moderator
Last seen: February 3, 2020

213
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.

Your reply