Aug 03 2021 03:08 PM
Aug 03 2021 03:08 PM
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.
Team 1 is B2
Team 2 is B4
I need the cell the formula is typed in to stay blank until the word Team 1 or Team 2 is typed in cell C3.
I feel like I'm getting close but I can't seem to get it. Any suggestions are appreciated.
Aug 03 2021 07:32 PM
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
Aug 04 2021 03:36 PM
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.
Aug 05 2021 07:06 PM
Aug 06 2021 07:10 AM
Aug 06 2021 08:41 AM
Let me help you understand, then. Thank you for apologizing. In brief, everything you posted after your first was very curt and uninformative. In my first response, I gave you a formula that did what you requested. You came back with the curt
but "that" --if you'd really used the formula I sent--does not give you a #NAME error. So I replied asking for more information on what it actually was that you tried, what the actual formula was that you'd written, not just an ambiguous "that"...and then I attached a working spreadsheet that included the working formula.
To which you replied with an even more curt and dismissive
I don't have any idea what "Spoiler" was about, clicking on it revealed a blank screen. And the attached spreadsheet with your formula gave FALSE (not #NAME) in the cell where your formula was written. I still see no evidence that you've done anything with the working formula I gave you.
So that last posting from you was about as unhelpful, uncommunicative--and, yes, rude--posting that I can imagine. It says nothing about the formula and spreadsheet I'd given you, it has that mysterious "Spoiler" box, and a still not working effort of your own.
THAT is why I said if you want to continue then you need to be more communicative.
I'd be happy to continue if you can be more communicative. I like helping people resolve questions regarding Excel, but there does need to be more two-way give and take.