I'm using Win7 Excel 2010. The following formula (in cell H2) works to returns today's date when the cells in the range contain text, and returns nothing when there is a mix of text and numbers:
In the cells in that range, I enter [same], [none], [removed], [new record], or the date information was updated. If all 5 cells contain text, H2 should show the date the data was entered; if one of them contains a date, this is not necessary. My goal is this: H2 should be blank if the range contains text or any blank cells; otherwise, it should return today's date.
The problem is this: The formula also returns today's date if there are one or more blank cells in the range. So, how to ignore blank cells?
Probably a simple thing, and I've found several examples for A blank cell but not for blank cellS. I much appreciate your help and patience. My questions, I promise, will become less ignorant with time and medication. Thanks very much.
All apologies. No offense intended. I needed to rush out of the office and did not want folks crunching code on my behalf unnecessarily. I'll do better next time.
My solution is hardly my own. I cobbled it together from pieces I found all over the place. It seems to work, but if I can get a solid understanding of WHY it works, I'll be a bit further on my way to having been taught to fish and feeding myself for a lifetime.
Your suggestion actually helps quite a lot. I tried nested IF statements but could not get them to work. I see now that at least part of the problem was that I thought each IF had to be enclosed in parentheses in situ rather than all at the end. So thanks very much, BrianGreen!