SOLVED

IF wildcard, then use a set value in another cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1542241%22%20slang%3D%22en-US%22%3EIF%20wildcard%2C%20then%20use%20a%20set%20value%20in%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542241%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20doesn't%20seem%20to%20be%20any%20easy%20way%20to%20do%20this.%3C%2FP%3E%3CP%3E-%20Cell%20H30%20is%20a%20cell%20where%20a%20person%20can%20type%20in%20anything.%3C%2FP%3E%3CP%3E-%20IF%20any%20text%20at%20all%20is%20entered%20into%20H30%2C%20THEN%26nbsp%3B%20F30%20should%20should%20display%20the%20number%201.%3C%2FP%3E%3CP%3E-%20IF%20nothing%20is%20entered%20in%20H30%2C%20THEN%20cell%20F30%20should%20be%20blank.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1542241%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1542264%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20wildcard%2C%20then%20use%20a%20set%20value%20in%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542264%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F737170%22%20target%3D%22_blank%22%3E%40Bonehead%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20asking%20a%20question%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20formula%2C%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DIF(H30%3D%22%22%2C%22%22%2C1)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Eplaced%20in%20cell%20F30%2C%20performs%20what%20you're%20describing%2C%20%3CU%3E%3CEM%3Ebut%3C%2FEM%3E%3C%2FU%3E%20you%20began%20with%20a%20reference%20to%20%22wildcard%22%20and%20I'm%20not%20able%20to%20figure%20out%20how%20that%20relates%20to%20the%20rest.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20you%20could%20clarify.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1542268%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20wildcard%2C%20then%20use%20a%20set%20value%20in%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542268%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F737170%22%20target%3D%22_blank%22%3E%40Bonehead%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20what%20you're%20looking%20for%3F%3C%2FP%3E%3CPRE%3E%3DIF(ISBLANK(%24H%2430)%2C%22%22%2C1)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1542280%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20wildcard%2C%20then%20use%20a%20set%20value%20in%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542280%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20waaaaaaay%20overthinking%20Excel.%3C%2FP%3E%3CP%3EI%20was%20trying%20to%20get%20a%20wildcard%20to%20say%20if%20you%20see%20anything%20in%20this%20cell%20then%20do%20'x'.%20When%20all%20I%20needed%20was%20to%20have%20the%20%3DIF(H30%3D%22%22%2C%22%22%2C1)...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMe%20BONEHEAD!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1542605%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20wildcard%2C%20then%20use%20a%20set%20value%20in%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542605%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F737170%22%20target%3D%22_blank%22%3E%40Bonehead%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EI've%20been%20waaaaaaay%20overthinking%20Excel.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20suspect%20we've%20all%20been%20there%2C%20and%20still%20can%20find%20ourselves%20there.%20It's%20often%20helpful%20to%20turn%20the%20presumed%20solution%20on%20its%20head%2C%20look%20at%20things%20from%20a%20totally%20different%20angle.......%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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 (Occasional 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.......