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")

"Adam" wrote:

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