If + Array

[PaulF]

Hello all !!

I'm trying to accomplish this:

=IF(A2={3,4,8,9},"Do True Stuff","Do False Stuff")

The 1st number will match, but not the rest of the array... *scratcheshead*

^^ I've tied various ways of doing this... Is this possible and I'm just missing the proper syntax or am I barking up the wrong tree ??

Paul

 

[Chihiro]

You need to enter formula as Array (Ctrl + Shift + Enter).

 

[PaulF]

{=IF(A2={3,4,8,9},TRUE,FALSE)} See attached... Still returning false...

 

[eibi]

You're doing it right -- -- and your formula is returning the right answers:

{FALSE,TRUE,FALSE,FALSE}

But only the first result displays in the cell where you type the formula.

What is the desired/expected output?

 

[PaulF]

My objective is A2 = Any of the numbers in the ARRAY...
Sorry I did not explain that...

 

[Deepak]

It will not work in that way in the simple argument.

Workaround is

MATCH(A2,{3,4,8,9},0)

 

[Chihiro]

Ahh, I see. I misunderstood the requirement.

This will return TRUE or False
=IFERROR(MATCH(A2,{3,4,8,9},0)>0,FALSE)

Or if you want to do different operation for TRUE, FALSE
=IF(ISERROR(MATCH(A2,{3,4,8,9},0)>0),FALSE,TRUE)

 

[PaulF]

{=IF(--IFERROR(MATCH(VALUE(RIGHT([@[UNIX Flavor]],1)),{3,4,8,9},0)>0,FALSE)=1,"EOL",IF(OR([@[Wintel_UNIX]]="WINTEL",[@[UNIX Flavor]]="EOL"),"",IF(AND(VALUE(RIGHT([@[UNIX Flavor]],1))=6,VALUE(RIGHT([@[Combined UNIX CMDB+Manual]],1))>5),"Current",IF(AND(VALUE(RIGHT([@[UNIX Flavor]],1))=5,VALUE(RIGHT([@[Combined UNIX CMDB+Manual]],2))>10),"Current",IF(OR([@[Combined UNIX CMDB+Manual]]="2014-12",[@[Combined UNIX CMDB+Manual]]="2015-06"),"Current","Need Patching")))))}

All is good now Filled the column and for thousands of UNIX sevvers (RedHat 3/4/5/6, Solarix 8/9/10/11, HP-UX, and AIX) with various patch dates I can see now what needs patching, what is current, and what is end of Life... Thank you for the assistance...

 

[NARAYANK991]

Hi Paul ,

An alternative is :

=OR(A2={3,4,8,9})

Narayan