This should do it.

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

--
Best Regards,

Luke M


"Connie Martin" wrote:

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