Help simplifying IF OR formula
=(COUNTIF(A2:D2,A1)0)+0
"Divya" wrote:
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!
|