PLEEEEEASE HELP
 

I've try associate IF OR AND all toghether
like

IF cell A4 1 AND ( cell A5 = "AAA" OR Cell A6 = "BBB" ) Then ...

but not with sucess

I apreciate your help
cc

PLEEEEEASE HELP
 

Try it like this:

=IF(AND(A41,OR(A5="AAA",A6="BBB")), action_if_true, action_if_false)

Hope this helps.

Pete

On Jan 11, 9:36*am, CC wrote:
I've try associate IF OR AND * * *all toghether
like

IF *cell A4 1 * * AND * ( cell A5 = "AAA" *OR Cell A6 *= "BBB" ) * Then ...

but not with sucess

I apreciate your help
cc

PLEEEEEASE HELP
 

It works

Thank you Pete
cc



"Pete_UK" wrote:

Try it like this:

=IF(AND(A41,OR(A5="AAA",A6="BBB")), action_if_true, action_if_false)

Hope this helps.

Pete

On Jan 11, 9:36 am, CC wrote:
I've try associate IF OR AND all toghether
like

IF cell A4 1 AND ( cell A5 = "AAA" OR Cell A6 = "BBB" ) Then ...

but not with sucess

I apreciate your help
cc

PLEEEEEASE HELP
 

You're welcome - thanks for feeding back.

Pete

On Jan 11, 11:09*am, CC wrote:
It works

Thank you Pete
cc



"Pete_UK" wrote:
Try it like this:

=IF(AND(A41,OR(A5="AAA",A6="BBB")), action_if_true, action_if_false)

Hope this helps.

Pete

On Jan 11, 9:36 am, CC wrote:
I've try associate IF OR AND * * *all toghether
like

IF *cell A4 1 * * AND * ( cell A5 = "AAA" *OR Cell A6 *= "BBB" ) * Then ...

but not with sucess

I apreciate your help
cc- Hide quoted text -

- Show quoted text -