IF statement needed
=IF(LEFT(C2)="4","P",IF(LEFT(C2)="7","S",""))
--
David Biddulph
"Connie Martin" wrote in message
...
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
|