View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Iriemon Iriemon is offline
external usenet poster
 
Posts: 89
Default 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,""))