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



Can I modify this:

=IF(MID(N3;6;3)="OLA";MID(N3;6;3)&LEFT(N3;3);Y3&MI D(N3;6;1))

to include this:

If AP3="PA-OUT" then ("PA" & LEFT(n3;3))

Thank you in advance.