Help simplifying IF OR formula

[Divya]

Hi,

Can I write this a better/simpler way?

IF(OR(A2=$A$1, B2 = $A$1, C2 = $A$1, D2= $A$1),1,0)

Basically comparing a range of cells to one value and returning 1 if true,
and 0 if false

Much appreciated!

 

[Teethless mama]

=(COUNTIF(A22,A1)>0)+0

 

[T. Valko]

Maybe this:

=--(COUNTIF(A22,$A$1)>0)

 

[Rick Rothstein]

While I would go with the COUNTIF method already posted, I just thought it
interesting that this simple array-entered** formula works also...

=OR($A$1=A22)

**Commit formula using Ctrl+Shift+Enter, not just Enter by itself.

 

[Teethless mama]

This one doesn't required "array-entered"

=--OR(INDEX(A22=$A$1,))

 

[Rick Rothstein]

But it is SO much longer... <bg>

 

[mubashir aziz]

@ Mama you formula is cool .......

@Rick your formula is short but will not return 1 or 0 until & unless
you will use negation ....

=--(OR($A$1=A22))
press Ctrl+Shift+Enter (CSE)

This one doesn't required "array-entered"

=--OR(INDEX(A22=$A$1,))