Can I modify this:
=IF(MID(N3;6;3)="OLA";MID(N3;6;3)&LEFT(N3;3);Y3&MID(N3;6;1))
to include this:
If AP3="PA-OUT" then ("PA" & LEFT(n3;3))
Thank you in advance.
Can I modify this:
=IF(MID(N3;6;3)="OLA";MID(N3;6;3)&LEFT(N3;3);Y3&MID(N3;6;1))
to include this:
If AP3="PA-OUT" then ("PA" & LEFT(n3;3))
Thank you in advance.
More info needed. What is the requirement in English?
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"carl" <[email protected]> wrote in message
news:[email protected]...
>
>
> Can I modify this:
>
> =IF(MID(N3;6;3)="OLA";MID(N3;6;3)&LEFT(N3;3);Y3&MID(N3;6;1))
>
> to include this:
>
> If AP3="PA-OUT" then ("PA" & LEFT(n3;3))
>
> Thank you in advance.
Here's one way:
IF(AP3="PA-OUT";"PA"&LEFT(n3;3);IF(MID(N3;6;3)="OLA";MID(N3;6;3)&LEFT(N3;3);Y3&MID(N3;6;1)))
This will look at AP3 first.
Hope this helps.
Pete
carl wrote:
> Can I modify this:
>
> =IF(MID(N3;6;3)="OLA";MID(N3;6;3)&LEFT(N3;3);Y3&MID(N3;6;1))
>
> to include this:
>
> If AP3="PA-OUT" then ("PA" & LEFT(n3;3))
>
> Thank you in advance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks