PLEEEEEASE HELP

[CC]

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

 

[Pete_UK]

Try it like this:

=IF(AND(A4>1,OR(A5="AAA",A6="BBB")), action_if_true, action_if_false)

Hope this helps.

Pete

 

[CC]

It works

Thank you Pete
cc

Try it like this:

=IF(AND(A4>1,OR(A5="AAA",A6="BBB")), action_if_true, action_if_false)

Hope this helps.

Pete

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

It works

Thank you Pete
cc







- Show quoted text -