IF Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

carl - 17 Aug 2006 16:30 GMT

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.

Reply to this Message

Bob Phillips - 17 Aug 2006 16:36 GMT

More info needed. What is the requirement in English?

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Can I modify this:
>
[quoted text clipped - 5 lines]
>
> Thank you in advance.

Reply to this Message

Pete_UK - 17 Aug 2006 16:38 GMT

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

> Can I modify this:
>
[quoted text clipped - 5 lines]
>
> Thank you in advance.

Reply to this Message