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...
Try this formula: =IFS(C3="","",C3=B2,B4,C3=B4,B2)
I replicated your little diagram with this formula in cell A1 and it stayed blank until I put one of the entries into Cell C3.
The IFS function is a good one to add to your repertoire. It can easily handle multiple conditions and consequences. Here's a good explanation of it. https://exceljet.net/excel-functions/excel-ifs-function
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 ""