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.

PReagan's avatar
PReagan
Bronze Contributor
Jul 23, 2020

Hello Bonehead,

 

Is this what you're looking for?

=IF(ISBLANK($H$30),"",1)