SOLVED

# IF wildcard, then use a set value in another cell

Occasional Contributor

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

4 Replies
Best Response confirmed by Bonehead (Occasional Contributor)
Solution

# Re: IF wildcard, then use a set value in another cell

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.

# Re: IF wildcard, then use a set value in another cell

Is this what you're looking for?

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

# Re: IF wildcard, then use a set value in another cell

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

# Re: IF wildcard, then use a set value in another cell

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