Results 1 to 2 of 2

Thread: Help with formulas with multiple conditions

  1. #1

    Help with formulas with multiple conditions



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

    Please help, I need to calculate the difference between 2 dates using multiple conditions, see attached, thank you.
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =IFERROR(IF(B4=$F$1,D4-INDEX($D$4:$D$392,MATCH(1,INDEX(($B$4:$B$392=$F$2)*($A$4:$A$392=A4)*($E$4:$E$392=E4),0),0)),""),"")

    copied down.

    If you don't want the 0 results to show, then format the range as Custom with Type: 0;-0;;@


Posting Permissions

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