=IF(AND(K23,K2<=4,D20,D2<25),10,IF(AND(K22.4,K2 <=3,D20,D2<25),11))

No need to separate the criteria...

"Iriemon" wrote:

I'm getting confused!!
Here is what I am tryng to accomplish:

IF K23 and <= 4
AND
D20 and <25

put in a 10

IF K22.4 and <=3
AND
D20 and <25

put in an 11


Do I have an extra AND at the beginning of the IF's in this formula?

=IF(AND(AND($K23,$K2<=4),AND($D20,$D2<25)),10,IF (AND(AND($K22.4,$K2<=3,AND($D20,$D2<25)),11,""))