IF statement needed

[Connie Martin]

How would I write this IF statement:
If C2 begins with 4 put "P", if C2 begins with 7 put "S", otherwise put
nothing?

Thank you so much. Connie

 

[Pete_UK]

Try this:

=IF(LEFT(C2,1)="4","P",IF(LEFT(C2,1)="7","S",""))

Hope this helps.

Pete

 

[David Biddulph]

=IF(LEFT(C2)="4","P",IF(LEFT(C2)="7","S",""))

 

[Luke M]

This should do it.

=IF(LEFT(C2,1)="4","P",IF(LEFT(C2,1)="7","S",""))

 

[Connie Martin]

Luke, Pete and David, thank you so much! You all had the same answer and it
works fabulously. Connie

 

[Luke M]

Your welcome. Thanks for the feedback!

 

[David Biddulph]

You're welcome, Connie. I'd made it slightly shorter by using just
LEFT(C2), rather than LEFT(C2,1), but the result should be the same.