to AND or OR remote reference?
 

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

to AND or OR remote reference?
 

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

to AND or OR remote reference?
 

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

to AND or OR remote reference?
 

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

to AND or OR remote reference?
 

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

to AND or OR remote reference?
 

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

to AND or OR remote reference?
 

Hi, like your equation, will keep trying, up all night, crashing now, but you
can reply if you think know about this:
- your example below with my cells is exact same as what trying to use, but
still get true for either 1 or 2 for N, where am9:an9 am using a false and a
neg.. (repeat: getting a positive when anding them together with this: using
a 2 for N or an3, should get a false, right?
-anyways, when as follows, I get my forward response for a true or not true
with <an3. don't know why that appears to work, but will figure out later,
unless you see the error of my way... thanks much. night

=IF(T9="","",IF(COUNTIF(AM9:AN9,"="&$AN$7)<$AN$3 ,"T",""))

"Dana DeLouis" wrote:

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

to AND or OR remote reference?
 

thanks, looks like that is it. was just worried about my output (using
different formatting for number: 1.0 = 1M (to reduce size of cell), so:
=IF(T9="","",IF(COUNTIF(AM9:AN9,"="&($AN$7*100000 0))=$AN$3,"T",""))

"Dana DeLouis" wrote:

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

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

to AND or OR remote reference?
 

sorry for all the replies, in case anyone wanted the correct answer for what
I was doing: missed a character (=) in the equation to make it work,
correct is:

=IF(T237="","",IF(COUNTIF(AM237:AN237,"="&($AN$7* 1000000))=$AN$3,"T",""))

"nastech" wrote:

thanks, looks like that is it. was just worried about my output (using
different formatting for number: 1.0 = 1M (to reduce size of cell), so:
=IF(T9="","",IF(COUNTIF(AM9:AN9,"="&($AN$7*100000 0))=$AN$3,"T",""))

"Dana DeLouis" wrote:

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

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