CELL = YES or Other text return value [Solved/Closed]
Jason -
Feb 11, 2016 at 02:15 PM - Latest reply:
vcoolio
1173
Posts
Thursday July 24, 2014Registration dateModeratorStatus
July 15, 2018
Last seen
- Feb 12, 2016 at 04:07 AM
- CELL = YES or Other text return value
- If cell contains text return value (Solved) » Forum - Excel
- Formula for if cell contains word, assign value for multiple » Forum - Excel
- Look at two different cells, refer to a 3rd, return value in 4th » Forum - Excel
- Excel if range of cell contain a text put a cell value in » Forum - Excel
- Highlight cell if another cell contains any text (Solved) » Forum - Excel
2 replies
Best answer
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.
has helped 1665 users this month
Best answer
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.