L
Lupe
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 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