can you return 2 values for 2 different conditions?

[Oakey]

Im looking to extend this formula, so that if Cell A1 contains either the work Inbound or Outbound then it will return a different value

I want inbound to return INB and outbound to return OUB.

Currently i can get the inbound to work, but i want to add the 2nd condition. The formula im using is

=IF(ISNUMBER(SEARCH("inbound",A1)),"inb","")

How do i extend this to add the 2nd condition for outbound?

 

[Fluff]

How about
=IF(ISNUMBER(SEARCH("inbound",A1)),"inb",IF(ISNUMBER(SEARCH("outbound",A1)),"oub",""))

 

[Rick Rothstein]

Assuming a cell will contain the word "bound" only if it is inside the word "inbound" or "outbound", this formula will also work for you...

=IF(RIGHT(A2,5)="bound",UPPER(LEFT(A2,3)),"")