On Sep 3, 10:54*am, Pranav Vaidya
wrote:
Hi,

You can have these many conditions.

=IF(AND(A1=5,B12),"RED",IF(AND(A1<=5,B1=0),"GREE N",IF(AND(OR(AND(A1=5,B1*=0),A1<=5),B1<=5),"YELLO W",""))

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!!



" wrote:
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 -

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