Thread: If Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl Carl is offline
external usenet poster
  
Posts: 361
Default If Question
How do I put this into an excel formula ?

If this "MID(N3;6;3)" equals "OLA" then do this "MID(N3;6;3)&LEFT(N3;3)"

otherwise

Y3&MID(N3;6;3)

Thank you in advance.

Reply With QuoteReply With Quote