Wildcards in IF statement

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

RagDyer

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

Cumulative formula for word table 0
Page numbering with Merged Document and IF statements 1
Word VBA - Want to test if Full Name is NOT Present in document 0
Multiple IF Statement in Word 5
Matching literal text "???" in Word 2010 field code IF statement 2
Using FIND to highlight text (with dashes) 4
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Using Drop Down list to an If Statement to another Drop Down list 3

Top