Related:
- 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
- Excel - IF function with multiple words ✓ - Forum - Excel
- Excel: If Date =, then enter a value ✓ - Forum - Excel
- Excel if cell contains any text then return value ✓ - Forum - Excel
- If cell contains any text then return value ✓ - Forum - Excel
2 replies
vcoolio
- Posts
- 1269
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- January 4, 2021
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
- 1269
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- January 4, 2021
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.
Subscribe To Our Newsletter!
