You dont need those extra AND()'s. You can have those together in one.

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

If this post helps click Yes
---------------
Jacob Skaria


"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,""))