Results 1 to 2 of 2

Thread: iferror with and, less than greater than inbetween

  1. #1

    iferror with and, less than greater than inbetween



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,829
    Articles
    0
    Excel Version
    O365
    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)

Posting Permissions

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