OR function into a IF function

[Guest]

is it possible to use a cind of "OR" function into a "IF" function...

 

[Guest]

Yes for example the function below will put the word "TRUE" into the cell
where you put this function if the cell A1 has "Y" or "YES" in it.

=IF(OR(A1="Y",A1="YES"),"TRUE","FALSE")

 

[Max]

Yes, an example perhaps?

Put in C1: =IF(OR(A1=1,B1=2),"Yes","No")

If either A1 contains a "1" or B1 contains a "2"
(or if both conditions are true)
then C1 will return "Yes", otherwise C1 returns "No"

 

[Guest]

Thanks for your help....

 

[Max]

You're welcome !