| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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,"")) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement to check for numerical value | Excel Worksheet Functions | |||
| IF Statement to Check for Blanks | Excel Worksheet Functions | |||
| Using contents of a check box for an in statement | Excel Discussion (Misc queries) | |||
| How do I use a "check(ed) box" as a criteria in an "=if" statement | Excel Worksheet Functions | |||
| How do I check formatting in an if-then statement | Excel Worksheet Functions | |||
Threaded Mode
