My 1st and 2nd cond formula's work fine. I can't get the 3rd to work ?

Here's my 1st for (GREEN)
=IF(AND(M60,N6="Inc"),TRUE, FALSE))

Here's my 2nd for (YELLOW)
=IF(AND(M6<0,N6="Inc"),TRUE,FALSE))


This formula still returns a YELLOW format?
Here's my 3rd for (RED)
=IF(AND(M6<-0.1,N6="Inc"),TRUE,FALSE))


James A

You don't need to use the IF function but it'll work as is. Flip the 2nd and
3rd conditions.

Condition 1: (green)

AND(M60,N6="Inc")

Condition 2: (red)

AND(M6<-0.1,N6="Inc")

Condition 3 (yellow)

AND(M6<0,N6="Inc")

Biff

"James A" wrote in message
...
My 1st and 2nd cond formula's work fine. I can't get the 3rd to work ?

Here's my 1st for (GREEN)
=IF(AND(M60,N6="Inc"),TRUE, FALSE))

Here's my 2nd for (YELLOW)
=IF(AND(M6<0,N6="Inc"),TRUE,FALSE))


This formula still returns a YELLOW format?
Here's my 3rd for (RED)
=IF(AND(M6<-0.1,N6="Inc"),TRUE,FALSE))


James A

Of course, each formula starts with an equal sign!

Biff

"T. Valko" wrote in message
...
You don't need to use the IF function but it'll work as is. Flip the 2nd
and 3rd conditions.

Condition 1: (green)

AND(M60,N6="Inc")

Condition 2: (red)

AND(M6<-0.1,N6="Inc")

Condition 3 (yellow)

AND(M6<0,N6="Inc")

Biff

"James A" wrote in message
...
My 1st and 2nd cond formula's work fine. I can't get the 3rd to work ?

Here's my 1st for (GREEN)
=IF(AND(M60,N6="Inc"),TRUE, FALSE))

Here's my 2nd for (YELLOW)
=IF(AND(M6<0,N6="Inc"),TRUE,FALSE))


This formula still returns a YELLOW format?
Here's my 3rd for (RED)
=IF(AND(M6<-0.1,N6="Inc"),TRUE,FALSE))


James A

First of all, you can simplify your formulas and eliminate the IF():

=AND(M60,N6="Inc")

Then, just switch condition 2 and 3.

Once the formula evaluates *anything* less then 0, that condition is met
(equates to TRUE). It doesn't look any farther to even see the 3rd
condition.

#1 =AND(M60,N6="Inc")
#2 =AND(M6<-0.1,N6="Inc")
#3 =AND(M6<0,N6="Inc")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"James A" wrote in message
...
My 1st and 2nd cond formula's work fine. I can't get the 3rd to work ?

Here's my 1st for (GREEN)
=IF(AND(M60,N6="Inc"),TRUE, FALSE))

Here's my 2nd for (YELLOW)
=IF(AND(M6<0,N6="Inc"),TRUE,FALSE))


This formula still returns a YELLOW format?
Here's my 3rd for (RED)
=IF(AND(M6<-0.1,N6="Inc"),TRUE,FALSE))


James A