Forum Discussion

Bonehead's avatar
Bonehead
Copper Contributor
Jul 23, 2020
Solved

IF wildcard, then use a set value in another cell

There doesn't seem to be any easy way to do this.

- Cell H30 is a cell where a person can type in anything.

- IF any text at all is entered into H30, THEN  F30 should should display the number 1.

- IF nothing is entered in H30, THEN cell F30 should be blank.

 

excel
Formulas and Functions
  • mathetes's avatar
    mathetes
    Jul 23, 2020

    Bonehead 

     

    Are you asking a question?

     

    This formula,

    =IF(H30="","",1)

    placed in cell F30, performs what you're describing, but you began with a reference to "wildcard" and I'm not able to figure out how that relates to the rest.

     

    Perhaps you could clarify.

4 Replies

  • mathetes's avatar
    mathetes
    Gold Contributor
    Jul 23, 2020

    Bonehead 

     

    Are you asking a question?

     

    This formula,

    =IF(H30="","",1)

    placed in cell F30, performs what you're describing, but you began with a reference to "wildcard" and I'm not able to figure out how that relates to the rest.

     

    Perhaps you could clarify.

    • Bonehead's avatar
      Bonehead
      Copper Contributor
      Jul 23, 2020

      mathetes 

      I've been waaaaaaay overthinking Excel.

      I was trying to get a wildcard to say if you see anything in this cell then do 'x'. When all I needed was to have the =IF(H30="","",1)...

       

      Me BONEHEAD!

      • mathetes's avatar
        mathetes
        Gold Contributor
        Jul 23, 2020

        Bonehead 

         

        I've been waaaaaaay overthinking Excel.

         

        I suspect we've all been there, and still can find ourselves there. It's often helpful to turn the presumed solution on its head, look at things from a totally different angle.......