Wildcards in IF statement

  • Thread starter Thread starter Ant
  • Start date Start date
A

Ant

I'm trying to use a IF statement to determine if a text of 4 characters
second digit is a 2 to say "Happy" else "Sad". Ex. if "0204" then "Happy",
"Sad".

I can't get the wildcard characters to work.
 
You could use Left() if you wished, and return the same results:

=IF(LEFT(RIGHT(A1,3))="2","Happy","Sad")
 
You could use Left() if you wished, and return the same results:

=IF(LEFT(RIGHT(A1,3))="2","Happy","Sad")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use of Wildcard characters with replace 2
How can I use wildcards in IF statements and Macros 2
wildcard characters 2
Wildcard Character in IF formulas 2
How do I search without wildcards? 8
Excel Wildcard in Excel array formula 0
how to create a wildcard in MSQuery 1
Replacing using a wildcard 2

Back
Top