Jul 23 2020 11:43 AM
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.
Jul 23 2020 11:49 AM
Solution
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.
Jul 23 2020 11:50 AM
Jul 23 2020 11:53 AM
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!
Jul 23 2020 02:23 PM
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.......
Jul 23 2020 11:49 AM
Solution
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.