Hi, is it possible to choose whether to AND / OR from a single cell, to
affect the whole column? such as:

=$N$2(x100,y100)

where n2 says either "and" or "or"; thanks

No.
You can't do it this way, you must use either IF or use VBA to put a formula
in your cell according to the value in N2.

IF($N$2="AND", AND(x100,y100),OR(x100,y100))

"nastech" wrote:

Hi, is it possible to choose whether to AND / OR from a single cell, to
affect the whole column? such as:

=$N$2(x100,y100)

where n2 says either "and" or "or"; thanks

Thanks!..

"Yossi" wrote:

No.
You can't do it this way, you must use either IF or use VBA to put a formula
in your cell according to the value in N2.

IF($N$2="AND", AND(x100,y100),OR(x100,y100))

"nastech" wrote:

Hi, is it possible to choose whether to AND / OR from a single cell, to
affect the whole column? such as:

=$N$2(x100,y100)

where n2 says either "and" or "or"; thanks

Just an idea for a workaround. If x & y are together (as in A1,B1) then
maybe...

=COUNTIF(A1:B1,"100")=n

Where n represents how many you want above 100. Example, instead of Or, you
can use n=1 (at least one of them needs to be above 100), or n=2 (both need
to be above 100)
Again, just an idea.
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"nastech" wrote in message
...
Thanks!..

"Yossi" wrote:

No.
You can't do it this way, you must use either IF or use VBA to put a
formula
in your cell according to the value in N2.

IF($N$2="AND", AND(x100,y100),OR(x100,y100))

"nastech" wrote:

Hi, is it possible to choose whether to AND / OR from a single cell, to
affect the whole column? such as:

=$N$2(x100,y100)

where n2 says either "and" or "or"; thanks

Hi, thanks for the response, was trying to make that work with my inputs, can
you check my version: am trying to have a variable input, but does not come
up with a true for 1 true, 1 false, where an7 is variable, an3 is 1 or 2..

(double and) works, but is long:

=IF(T9="","",IF($AN$2="and",IF(AND(AM9/1000000=$AN$7,AN9/1000000=$AN$7),"T",""),IF(OR(AM9/1000000=$AN$7,AN9/1000000=$AN$7),"T","")))

attempt where an7 is supposed to be variable "in", not working:
is this correctable? thanks

=IF(T9="","",IF(COUNTIF(AM9:AN9,"=$AN$7")=$AN$3, "T",""))
=COUNTIF(A1:B1,"100")=N

"Dana DeLouis" wrote:

Just an idea for a workaround. If x & y are together (as in A1,B1) then
maybe...

=COUNTIF(A1:B1,"100")=n

Where n represents how many you want above 100. Example, instead of Or, you
can use n=1 (at least one of them needs to be above 100), or n=2 (both need
to be above 100)
Again, just an idea.
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"nastech" wrote in message
...
Thanks!..

"Yossi" wrote:

No.
You can't do it this way, you must use either IF or use VBA to put a
formula
in your cell according to the value in N2.

IF($N$2="AND", AND(x100,y100),OR(x100,y100))

"nastech" wrote:

Hi, is it possible to choose whether to AND / OR from a single cell, to
affect the whole column? such as:

=$N$2(x100,y100)

where n2 says either "and" or "or"; thanks

Hi. Not sure, but see if this general idea will work for you.

=IF(COUNTIF(AM9:AN9,"=" & $AN$7)=$AN$3,TRUE,FALSE)

Here's another technique. I'm guessing that it may be easier to read with
range names.

=((AM9=Ref)+(AN9=Ref))=n

(Will return True/False to the cell)

Where "Ref" (reference to $AN$7) and "n" (An3), refer to your two cells.

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"nastech" wrote in message
...
Hi, thanks for the response, was trying to make that work with my inputs,
can
you check my version: am trying to have a variable input, but does not
come
up with a true for 1 true, 1 false, where an7 is variable, an3 is 1 or 2..

(double and) works, but is long:

=IF(T9="","",IF($AN$2="and",IF(AND(AM9/1000000=$AN$7,AN9/1000000=$AN$7),"T",""),IF(OR(AM9/1000000=$AN$7,AN9/1000000=$AN$7),"T","")))

attempt where an7 is supposed to be variable "in", not working:
is this correctable? thanks

=IF(T9="","",IF(COUNTIF(AM9:AN9,"=$AN$7")=$AN$3, "T",""))
=COUNTIF(A1:B1,"100")=N

"Dana DeLouis" wrote:

Just an idea for a workaround. If x & y are together (as in A1,B1) then
maybe...

=COUNTIF(A1:B1,"100")=n

Where n represents how many you want above 100. Example, instead of Or,
you
can use n=1 (at least one of them needs to be above 100), or n=2 (both
need
to be above 100)
Again, just an idea.
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"nastech" wrote in message
...
Thanks!..

"Yossi" wrote:

No.
You can't do it this way, you must use either IF or use VBA to put a
formula
in your cell according to the value in N2.

IF($N$2="AND", AND(x100,y100),OR(x100,y100))

"nastech" wrote:

Hi, is it possible to choose whether to AND / OR from a single cell,
to
affect the whole column? such as:

=$N$2(x100,y100)

where n2 says either "and" or "or"; thanks