If cell begins with 8 then OS, else BS

Howdy!

Here is my first posted question:
I am entering data and want to know how to have the adjacent cell use an If-Then statement. The cell to the left has a FedEx tracking number. If the tracking number in cell D4 begins with an 8, I know the package was sent by OS. If the tracking number begins with any other number, it was sent by BS. Hmmm... Can you please tell me how to create a formula in cell E4 that would have OS entered if the tracking number begins with an 8, and then BS if it begins with anything else? Thanks!!!

Try:

Please Login or Register  to view this content.

WOWSA! Not only was that a lightning fast response, the formula worked like a charm! Thanks!!!!