| 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,"")) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check IF statement please
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,"")) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check IF statement please
Sorry, Jacob has it the way I want.
Thank again "Jacob Skaria" wrote: 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,"")) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check IF statement please
=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,"")) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check IF statement please
Both of you came up with the same solution, but when I tried it and neither
condition is met, it returns "FALSE". How do I get it to return "" (empty string) instead? Thanks "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,"")) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check IF statement please
They are not the same. Use Jacob's solution. It will return the empty string
for you. Regards, Fred. "Iriemon" wrote in message ... Both of you came up with the same solution, but when I tried it and neither condition is met, it returns "FALSE". How do I get it to return "" (empty string) instead? Thanks "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,"")) |
| Reply |
| 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 | |||
Hybrid Mode
