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. ...
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.

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.......