"IF" question

[Adam]

I am trying to get cell BA2 to look at BA1 and say "Yes" if BA1 is equal to
either "1" or "3". I know this should be simple, but for the life of me I
can't remember how to write this.

Thanks

 

[Jacob Skaria]

Try the below in cell BA2
=IF(OR(BA1=1,BA1=3),"Yes","")

If this post helps click Yes

 

[Eduardo]

Hi,
=if(or(BA1=1,BA1=3),"YES","")

I assume you wanted a blank space if the values are not 1 or 3 is you want
no use

=if(or(BA1=1,BA1=3),"YES","NO")

 

[T. Valko]

One way:

=IF(OR(BA1={1,3}),"Yes","")