| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
