If / And / Or Macro
 

Basic question: I am trying to write a macro that looks to see whether A1 =
"X" and also if any of A2...10 = "Y", then Statement A, else Statement B.
Thank you in advance.

If / And / Or Macro
 

Try this

=IF(AND(A1="x",COUNTIF(A2:A10,"y")0),"Statement A","Statement B")

Mike

"Graeme" wrote:

Basic question: I am trying to write a macro that looks to see whether A1 =
"X" and also if any of A2...10 = "Y", then Statement A, else Statement B.
Thank you in advance.

If / And / Or Macro
 

Mike - thanks for the quick response. I see how this would work as an excel
formula, but if it's a line of code in a macro, does it need to be expressed
differently? thanks.

"Mike H" wrote:

Try this

=IF(AND(A1="x",COUNTIF(A2:A10,"y")0),"Statement A","Statement B")

Mike

"Graeme" wrote:

Basic question: I am trying to write a macro that looks to see whether A1 =
"X" and also if any of A2...10 = "Y", then Statement A, else Statement B.
Thank you in advance.

If / And / Or Macro
 

Please state your question in the context of its environment. Don't waste
our time.

Tyro

"Graeme" wrote in message
...
Basic question: I am trying to write a macro that looks to see whether A1
=
"X" and also if any of A2...10 = "Y", then Statement A, else Statement B.
Thank you in advance.