# Thread: iferror with and, less than greater than inbetween

1. ## iferror with and, less than greater than inbetween

hi,

i have a formula

=SUMPRODUCT((\$C\$4:\$C\$32600="W")*(G\$5:G\$32601="PICK")* (IFERROR(\$J\$3:\$J\$32599-\$C\$7:\$C\$32603;2)<=2/24);G\$4:G\$32600)

1.how do i write the

(IFERROR(\$J\$3:\$J\$32599-\$C\$7:\$C\$32603;2)<=2/24)

so it is not less than 2/24 but in in between 0,1/24 and 0,5/24(greater than 0,1 AND less than 0,5).

2. is it necesary to write <= or does it always work fine with < or >. What is the difference if you write "<" or just <?

3. is the only way with command AND or is there some other way?

..........................

i tryed the formula

=SUMPRODUCT((\$C\$4:\$C\$32600="W")*(G\$5:G\$32601="PICK")*(IFERROR(\$J\$3:\$J\$32599-\$C\$7:\$C\$32603;2)and(>0,1/24;<0,5/24));G\$4:G\$32600)

it returns an error..
why doesnt this work?  Reply With Quote

2. Because it is syntactically incorrect.

Try

=SUMPRODUCT((\$C\$4:\$C\$32600="W")*(G\$5:G\$32601="PICK")*(IFERROR(\$J\$3:\$J\$32599-\$C\$7:\$C\$32603;2)>0,1/24)* (IFERROR(\$J\$3:\$J\$32599-\$C\$7:\$C\$32603;2)<0,5/24);G\$4:G\$32600)  Reply With Quote

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•