IF function in Excel

[kabushnell]

I have a row of data that I want to use the IF function to return another value. There are two sets of data.

One has Sold with a price and date following, the other has Purchased with a price and date.

What I would like to do is have the formula look at the cell and return B if it was a purchase and S if it was sold.

Any ideas? I tried the IF function but with the different prices and dates I can't make it work.

 

[carrr]

Let's say A1 has your data. Wouldn't =IF(A1=Sale,"S","B&quot suffice?

 

[kabushnell]

that is what I had but it does not work. The reference sell contains more than just "sold" or "purchased". It contains something like Sold 4/14/02 145.67, etc.

 

[bluedragon2]

=IF(LEFT(A1,4)="Sold","S","B&quot

 

[is1ma1il]

=IF((FIND("sold",A1))>=1,"S","B&quot

try this.

 

[kabushnell]

Works great. Thanks