Check IF statement please
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,""))
|