Hi, I need to check on 2 columns to give me the following.
If G2 <= 0 and P2 < 12 "do nothing".
If G2 <=0 and P2 = 12 "incorrect"
If G2 0 and P2 = 12 "correct"
Here is my formula, but it does not work. I am sure missing something but I
cannot see it.
=IF($G2<=0,IF(AND($P2<12),"do
nothing",IF(AND($P2=12),"incorrect","correct")))
Thanks, Lupe

=IF(AND(G2<=0,P2=12),"incorrect",IF(AND(G20,P2=12 ),"correct",""))


"Lupe" wrote:

Hi, I need to check on 2 columns to give me the following.
If G2 <= 0 and P2 < 12 "do nothing".
If G2 <=0 and P2 = 12 "incorrect"
If G2 0 and P2 = 12 "correct"
Here is my formula, but it does not work. I am sure missing something but I
cannot see it.
=IF($G2<=0,IF(AND($P2<12),"do
nothing",IF(AND($P2=12),"incorrect","correct")))
Thanks, Lupe

Let's see
if(g2<=0,cond1,cond2)
cond1 if(p2=12,"i","")
cond2 if(p2=12,"c","")

OR keys on p2 first

=IF(p2=12,IF(g2<=0,"i","c"),"")
--
Don Guillett
SalesAid Software

"Lupe" wrote in message
...
Hi, I need to check on 2 columns to give me the following.
If G2 <= 0 and P2 < 12 "do nothing".
If G2 <=0 and P2 = 12 "incorrect"
If G2 0 and P2 = 12 "correct"
Here is my formula, but it does not work. I am sure missing something but
I
cannot see it.
=IF($G2<=0,IF(AND($P2<12),"do
nothing",IF(AND($P2=12),"incorrect","correct")))
Thanks, Lupe

Thanks you Teethless mama.
I have added and changed it a little bit to better reflect what we needed
and it works:
=IF(AND($G3<=0,$P3=12),"change to
01",IF(AND($G30,$P3=12),"correct",IF(AND($G30,$P 3<12),"change to 12","do
nothing")))

"Teethless mama" wrote:

=IF(AND(G2<=0,P2=12),"incorrect",IF(AND(G20,P2=12 ),"correct",""))


"Lupe" wrote:

Hi, I need to check on 2 columns to give me the following.
If G2 <= 0 and P2 < 12 "do nothing".
If G2 <=0 and P2 = 12 "incorrect"
If G2 0 and P2 = 12 "correct"
Here is my formula, but it does not work. I am sure missing something but I
cannot see it.
=IF($G2<=0,IF(AND($P2<12),"do
nothing",IF(AND($P2=12),"incorrect","correct")))
Thanks, Lupe

Don,
I'm leaving the office at the moment but I will check tomorrow whether this
statement also works for me.
Thanks, Lupe

"Don Guillett" wrote:

Let's see
if(g2<=0,cond1,cond2)
cond1 if(p2=12,"i","")
cond2 if(p2=12,"c","")

OR keys on p2 first

=IF(p2=12,IF(g2<=0,"i","c"),"")
--
Don Guillett
SalesAid Software

"Lupe" wrote in message
...
Hi, I need to check on 2 columns to give me the following.
If G2 <= 0 and P2 < 12 "do nothing".
If G2 <=0 and P2 = 12 "incorrect"
If G2 0 and P2 = 12 "correct"
Here is my formula, but it does not work. I am sure missing something but
I
cannot see it.
=IF($G2<=0,IF(AND($P2<12),"do
nothing",IF(AND($P2=12),"incorrect","correct")))
Thanks, Lupe