Need help with IF CELL = RANGE ,TRUE,FALSE

January 24, 2011 at 08:28:34
Specs: Windows 7
=IF(A1=B1:B5,true,false)

Hey Guys,
I need a formula that will return true or false if cell A1 matches cell B1,B2,B3,B4 or B5.
Is my formula close? Does anyone have any suggestions?
Thank you.


See More: Need help with IF CELL = RANGE ,TRUE,FALSE

Report •

#1
January 24, 2011 at 09:32:33
=IF(OR(A1=B1, A1=B2, etc.), TRUE, FALSE)

or (better)

=IF(COUNTIF(B1:B5,A1)>0, TRUE, FALSE)


Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
January 24, 2011 at 10:01:24
=IF(COUNTIF(B1:B5,A1)>0, TRUE, FALSE)

Thank you very much this worked perfectly!!!!


Report •
Related Solutions


Ask Question