CELL = YES or Other text return value
Solved/Closed
Jason
-
Feb 11, 2016 at 02:15 PM
vcoolio Posts 1364 Registration date Thursday July 24, 2014 Status Moderator Last seen February 10, 2023 - Feb 12, 2016 at 04:07 AM
vcoolio Posts 1364 Registration date Thursday July 24, 2014 Status Moderator Last seen February 10, 2023 - Feb 12, 2016 at 04:07 AM
Related:
- If cell contains yes then return value
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- If cell contains specific text then return value in another cell vba ✓ - Excel Forum
- If cell contains text then return value in another cell ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
2 replies
vcoolio
Posts
1364
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 10, 2023
252
Feb 12, 2016 at 03:58 AM
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
Posts
1364
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 10, 2023
252
Feb 12, 2016 at 04:07 AM
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.