Hello--I am a novice with respect to conditional if statements. I
would like to express the following in a formula:

If cell A =5 AND cell B2, return Red
If cell A<=5 AND cell B=0, return Green
If cell A=5 AND cell B=0 OR Cell A<=5 AND cell B=2-5, Return Yellow.

I know this is a lot. What I would like to know is whether it is even
possible to include this many conditions.

Thanks!

=IF(AND(A2=5,B22),"Red",IF(AND(A2<=5,B2=0)<"Gree n",IF(OR(AND(A2=5,B2=0),AND(A2<=5,B2=2)),"Yellow" ,"")))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
...
Hello--I am a novice with respect to conditional if statements. I
would like to express the following in a formula:

If cell A =5 AND cell B2, return Red
If cell A<=5 AND cell B=0, return Green
If cell A=5 AND cell B=0 OR Cell A<=5 AND cell B=2-5, Return Yellow.

I know this is a lot. What I would like to know is whether it is even
possible to include this many conditions.

Thanks!

On Sep 3, 10:19*am, "Bob Phillips" wrote:
=IF(AND(A2=5,B22),"Red",IF(AND(A2<=5,B2=0)<"Gree n",IF(OR(AND(A2=5,B2=0),*AND(A2<=5,B2=2)),"Yellow ","")))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message

...



Hello--I am a novice with respect to conditional if statements. *I
would like to express the following in a formula:

If cell A =5 AND cell B2, return Red
If cell A<=5 AND cell B=0, return Green
If cell A=5 AND cell B=0 OR Cell A<=5 AND cell B=2-5, Return Yellow.

I know this is a lot. *What I would like to know is whether it is even
possible to include this many conditions.

Thanks!- Hide quoted text -

- Show quoted text -

Hi Bob--thanks so much for the quick response. I think this is on the
verge of working, but everything returns as "FALSE." The values in
column A are all percentages. I did not think this would matter, but
could that be what is throwing me off?