Another 'IF' question (keep you busy)

  • Thread starter Thread starter digitallifeform
  • Start date Start date
D

digitallifeform

OK (don't know what i would do without you all!)

I am trying to do an IF statement that will allow 3 different answer
as a true statement.

For example:

Logical Test: P27=B2 or B3 or B4

So i need it to allow any of those cells, im sure it's easy but i
still learning....

Any help is very much apreciated.

Darre
 
=IF(OR(P27=B2,P27=B3,P27=B4),"do this","do that")

or

=IF(ISNUMBER(MATCH(P27,B2:B4,0)),"do this","do that")

if there are more conditions (and they are in one range) eventually the
second formula will be shorter
 
Back
Top