SOLVED

IF wildcard, then use a set value in another cell

Copper Contributor

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 (Copper Contributor)
Solution

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

Hello @Bonehead,

 

Is this what you're looking for?

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

@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!

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

1 best response

Accepted Solutions
best response confirmed by Bonehead (Copper Contributor)
Solution

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

View solution in original post