Conditional If Statements

[jesoldano]

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 B>2, 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!

 

[Mike H]

what's wrong with the answer in your other thread?

 

[Pranav Vaidya]

Hi,

You can have these many conditions.

=IF(AND(A1>=5,B1>2),"RED",IF(AND(A1<=5,B1=0),"GREEN",IF(AND(OR(AND(A1>=5,B1=0),A1<=5),B1<=5),"YELLOW",""))

You may need to twick this as I have not completely tested this. It would
have been a lot easier with some sample data.
HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think a post is useful, please rate it as an ANSWER, it will help
others!!

 

[jesoldano]

Hi,

You can have these many conditions.

=IF(AND(A1>=5,B1>2),"RED",IF(AND(A1<=5,B1=0),"GREEN",IF(AND(OR(AND(A1>=5,B1­=0),A1<=5),B1<=5),"YELLOW",""))

You may need to twick this as I have not completely tested this. It would
have been a lot easier with some sample data.
HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think a post is useful, please rate it as an ANSWER, it will help
others!!








- Show quoted text -

Hello--thanks so much for your help. I know it would be easier for me
to provide data, but unfortunately the data is confidential. The
formula you provided is working, but is only returing
"Yellow" (although I know that there should be a few reds and greens
as well). Any idea of why this may be?

 

[jesoldano]

Hi,

You can have these many conditions.

=IF(AND(A1>=5,B1>2),"RED",IF(AND(A1<=5,B1=0),"GREEN",IF(AND(OR(AND(A1>=5,B1­=0),A1<=5),B1<=5),"YELLOW",""))

You may need to twick this as I have not completely tested this. It would
have been a lot easier with some sample data.
HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think a post is useful, please rate it as an ANSWER, it will help
others!!








- Show quoted text -

Nevermind--I just fixed it! Thanks everyone for the help.