Forum Discussion

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

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

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