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.

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.

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.

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.