Using IF only when certain text is in the cell

[Nanaia]

I'm trying to tailor the IF command to put "SP" in a cell only if the referenced cell has FS in front of the number (i.e. FS101RR). FS will only be at the beginning of the entry, but isn't always there. What I've got isn't working which no doubt means it's not right. If there's not an FS in the referenced cell I want the target cell to be blank so I just put a space between two quotes. Can anybody help me figure out how to fix this? I know there's a way, but I just can't figure it out at the moment...

=IF(CSV!Z3=LEFT("FS",2)),"SP"," ")

 

[Joe4]

You are applying the LEFT function to your hard-coded string and not your cell.
Try:

[COLOR=#333333]=IF(LEFT(CSV!Z3,2)="FS","SP","")[/COLOR]

I want the target cell to be blank so I just put a space between two quotes.

Note that a single space is NOT the same as a blank entry. Use two double-quotes with NO spaces in between.

 

[Scott T]

Try

=IF(LEFT(CSV!Z3,2)="FP","SP","")

 

[Nanaia]

FABULOUS!~ Thank you! I appreciate the help!