If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"IF" question
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 |
#2
|
|||
|
|||
"IF" question
Try the below in cell BA2
=IF(OR(BA1=1,BA1=3),"Yes","") If this post helps click Yes --------------- Jacob Skaria "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 |
#3
|
|||
|
|||
"IF" question
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 |
#4
|
|||
|
|||
"IF" question
One way:
=IF(OR(BA1={1,3}),"Yes","") -- Biff Microsoft Excel MVP "Adam" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|