Forum Discussion
=if Formula need cell to stay blank until data is entered
I've been at this for a while and I can't seem to make this work. I have a cell I need to stay blank until a text is added to a different cell. Here is what the formula looks like. =IF(C3=B2,B4,IF...
Please attach your spreadsheet. You're doing something wrong if that's what you get. And/or be a bit more clear in describing what you've done. You say you "tried it": before or after my suggestion? Could you show us the formula you used?
Anyway, here's the working sample I created.
- Your point being?
Surely it isn't that the formula in that sheet is doing what you wanted it to. It doesn't stay blank until the winner is entered in C3. The formula I gave you works as you requested.
If you have any interest at all in continuing this exchange, I'd suggest trying a few more words of explanation--it's called "communicating"-- else ""- I'm not sure at what part of this exchange you were offended. For that I apologize. This was my first time using this site, or any site for that matter, to figure out formulas. I figured I'd give it a try. I do appreciate your help though. Have a good day.