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
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Feb 12, 2016 at 04:07 AM
Related:
- Use the ifs function to return 5 if cell a5 contains the value 3, and return a 6 if it contains any other number.
- Gta 5 download apk pc - Download - Action and adventure
- Hitman 3 cheats - Guide
- If cell contains date then return value ✓ - Excel Forum
- Psiphon 3 download - Download - VPN
- Excel formula to check if cell contains a date - Excel Forum
2 responses
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
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
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
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.