IF and OR statements

  • Thread starter Thread starter Nav
  • Start date Start date
N

Nav

I am not sure if this possible, but I need a if and or
statement in one.

I want to know (from a list) if any of the cells = Joe or
JB, if they do I want it to say CHECK otherwise I want it
blank.

Any ideas would be appreciated.

Thanks in advance
 
I am not sure if this possible, but I need a if and or
statement in one.

I want to know (from a list) if any of the cells = Joe or
JB, if they do I want it to say CHECK otherwise I want it
blank.

Any ideas would be appreciated.

Thanks in advance
Click to expand...

If your names are in a range named "list", then the *array-entered* formula:

=IF(OR(list="Joe",list="JB"),"CHECK","")

To *array-enter* a formula, after typing or copying it in, hold down
<ctrl><shift> while hitting <enter>. XL will place braces {...} around the
formula.


--ron
 
Nav said:
I am not sure if this possible, but I need a if and or
statement in one.

I want to know (from a list) if any of the cells = Joe or
JB, if they do I want it to say CHECK otherwise I want it
blank.

Any ideas would be appreciated.

Thanks in advance
Click to expand...

See if something like this is what you need:
=IF(OR(A1:A10={"Joe","JB"}),"CHECK","")
Note that this is an array formula, so it has to be entered with
CTRL+SHIFT+ENTER rather than just ENTER.
 
I am not sure if this possible, but I need a if and or
statement in one.

I want to know (from a list) if any of the cells = Joe or
JB, if they do I want it to say CHECK otherwise I want it
blank.

Any ideas would be appreciated.

Thanks in advance
Click to expand...

If your names are in a range named "list", then the *array-entered* formula:

=IF(OR(list="Joe",list="JB"),"CHECK","")

To *array-enter* a formula, after typing or copying it in, hold down
<ctrl><shift> while hitting <enter>. XL will place braces {...} around the
formula.


--ron
 
Back
Top