CELL = YES or Other text return value
Solved/Closed
Jason
-
Feb 11, 2016 at 02:15 PM
vcoolio
vcoolio
- Posts
- 1347
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- June 10, 2022
Related:
- If cell contains specific text then return value
- If cell contains yes then return value - Best answers
- Yes in cell - Best answers
- If cell contains specific text then return value in another cell vba ✓ - Forum - Excel
- If a cell contains a date then return value ✓ - Forum - Office Software
- If cell contains any text then return value in another cell ✓ - Forum - Excel
- If cell contains multiple text then return value ✓ - Forum - Excel
- Excel if cell contains partial text then return value in another cell - Guide
2 replies
vcoolio
Feb 12, 2016 at 03:58 AM
- Posts
- 1347
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- June 10, 2022
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.
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.
vcoolio
Feb 12, 2016 at 04:07 AM
- Posts
- 1347
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- June 10, 2022
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.
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.