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.
