If amount is whole number or equal to another column, TRUE; otherwise, FALSE

[brooklyn1976]

Hello,

I'm looking for formula that look at value in A3 and if that value is a whole number OR equal to value in A1 OR equal to value in A2, TRUE; otherwise FALSE.

Thanks!

 

[t0azt]

=if(or(a3=int(a3),a3=a1,a3=a2),"true","false")

 

[Rick Rothstein]

=if(or(a3=int(a3),a3=a1,a3=a2),"true","false")

Although your function is returning text values, I think the OP would be just as happy to have real Boolean values returned. If so, then the IF function call would not be needed...

=OR(A3=INT(A3),A3=A1,A3=A2)

 

[brooklyn1976]

Thanks very much!