Results 1 to 12 of 12

Nesting issues

Threaded View

kckliodna Nesting issues 09-06-2023, 03:23 PM
spudster656 Re: Nesting issues 09-06-2023, 04:21 PM
HansDouwe Re: Nesting issues 09-06-2023, 06:17 PM
kckliodna Re: Nesting issues 09-07-2023, 09:45 AM
HansDouwe Re: Nesting issues 09-07-2023, 11:24 AM
kckliodna Re: Nesting issues 09-07-2023, 03:36 PM
HansDouwe Re: Nesting issues 09-07-2023, 04:16 PM
kckliodna Re: Nesting issues 09-09-2023, 07:04 PM
kckliodna Re: Nesting issues 09-09-2023, 07:07 PM
HansDouwe Re: Nesting issues 09-09-2023, 11:58 PM
kckliodna Re: Nesting issues 09-12-2023, 10:01 AM
HansDouwe Re: Nesting issues 09-12-2023, 01:47 PM
  1. #1
    Registered User
    Join Date
    08-05-2023
    Location
    Michigan, US
    MS-Off Ver
    365
    Posts
    6

    Nesting issues

    Hello! I'm trying to create a nesting formula and I can get each one to work independently, but when I nest them altogether, some of them don't work anymore and I can't figure out why. Mainly, they are the ones where I'm trying to calculate an average if the amounts are all <=2.00. I do have separate formulas for the amounts >2.00 because those calculations depend on other factors which work both independently and in the nesting formula. I have tried changing the independent formulas to get them to work in the nest to no avail.
    This is where I left off at and I'm referencing Column I because that has two of the conditions that don't work. These are the segments that don't work in the nest:
    IF(OR(J4={"REF","OTDT"},AND($B$2:$P$2,"12",$B$3:$P$3,"OT W","<=2.00")),(AVERAGEIFS($B4:$P4,$B$3:$P$3,"OT W",$B4:$P4,">0.17",$B$3:$P$3,"OT W",$B4:$P4,"<=2.00")-$H4),
    IF(OR(J4={"REF","OTDT"},AND($B$2:$P$2,"10",$B$3:$P$3,"OT W","<=2.00")),(AVERAGEIFS($B4:$P4,$B$3:$P$3,"OT W",$B4:$P4,">0.17",$B$3:$P$3,"OT W",$B4:$P4,"<=2.00")-$H4),
    IF(OR(J4={"LV","SC"},AND($B$2:$P$2,"12",$B$3:$P$3,"OT W","<=2.00")),AVERAGEIFS($B4:$P4,$B$3:$P$3,"OT W",$B4:$P4,">0.17",$B4:$P4,"<2.01"),
    IF(OR(J4={"LV","SC"},AND($B$2:$P$2,"10",$B$3:$P$3,"OT W","<=2.00")),AVERAGEIFS($B4:$P4,$B$3:$P$3,"OT W",$B4:$P4,">0.17",$B4:$P4,"<2.01"),
    I have attached a shortened version of my worksheet to show the representative data. The formula will go under each Carrier's column labeled "U" (for unavailable).
    Any help/guidance would be much appreciated!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 05-10-2021, 11:21 AM
  2. Urgent nesting calculation issues
    By asills03 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-03-2018, 04:34 AM
  3. [SOLVED] Excel to Outlook Calendar date duplication issues and blank cells causing issues
    By singerbatfink in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 02-11-2016, 07:57 AM
  4. Replies: 4
    Last Post: 02-26-2015, 06:10 AM
  5. Nesting Issues
    By demoman369 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-17-2014, 06:59 PM
  6. Replies: 3
    Last Post: 07-16-2014, 01:50 AM
  7. Nesting issues
    By Shmem in forum Excel General
    Replies: 12
    Last Post: 11-12-2009, 08:07 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1