Forum Discussion

salgar23's avatar
salgar23
Copper Contributor
Aug 03, 2021

=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(C3=B4,B2))

Team 1 
vsC3
Team 2 

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. 

 

 

Formulas and Functions

7 Replies

  • mathetes's avatar
    mathetes
    Gold Contributor
    Aug 03, 2021

    salgar23 

     

    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

     

     

      • mathetes's avatar
        mathetes
        Gold Contributor
        Aug 04, 2021

        salgar23 

        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.

Resources