View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default IF statement needed

Try this:

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

Hope this helps.

Pete

On Dec 10, 8:35 pm, 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