+ Reply to Thread
Results 1 to 13 of 13

Nested IF function - dont know where to start

  1. #1
    Registered User
    Join Date
    12-04-2019
    Location
    Sweetwater, Texas
    MS-Off Ver
    365
    Posts
    8

    Nested IF function - dont know where to start

    I have a scheduling spreadsheet and need to add an "all" function.

    Currently, when the initials are selected the formula shown will add the scheduled time. When there are multiple people working on the same job, it divides the time evenly between them. What I need to do is add an "All" formula that when selected will divide the time evenly between all of the people.

    How would I set this up? Attached is a copy of the worksheet.
    Attached Files Attached Files
    Last edited by cDEVNEWB; 12-09-2019 at 06:08 PM. Reason: attachment format

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Nested IF function - dont know where to start

    please read the yellow banner at the top of the post and upload a sample workbook WITH expected results. It is very difficult to discern what you need from a small snapshot and I'm lazy and don't want to try to type in a workbook your data then try to guess what output you want.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    12-04-2019
    Location
    Sweetwater, Texas
    MS-Off Ver
    365
    Posts
    8

    Re: Nested IF function - dont know where to start

    thanks, its all fixed now

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,323

    Re: Nested IF function - dont know where to start

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Registered User
    Join Date
    12-04-2019
    Location
    Sweetwater, Texas
    MS-Off Ver
    365
    Posts
    8

    Re: Nested IF function - dont know where to start

    Not solved, just had the right attachment..sorry

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,323

    Re: Nested IF function - dont know where to start

    OK - understood.

    Please add an .xlsx version of your file - you have Office 365.

  7. #7
    Registered User
    Join Date
    12-04-2019
    Location
    Sweetwater, Texas
    MS-Off Ver
    365
    Posts
    8

    Re: Nested IF function - dont know where to start

    format fixed

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,323

    Re: Nested IF function - dont know where to start

    Your formulae contain external references, so I can’t see them on this iPad - sorry. What is the formula you are using?

  9. #9
    Registered User
    Join Date
    12-04-2019
    Location
    Sweetwater, Texas
    MS-Off Ver
    365
    Posts
    8

    Re: Nested IF function - dont know where to start

    =if(iserror(j6/sum(countifs(c6:i6,{"sw","jb","as","mv","ap","la","fm"}))),"",if(j6="c/w","",(j6/sum(countifs(c6:i6,{"sw","jb","as","mv","ap","la","fm"})))))

    this formula allows the sheet to divide the hours between the people... it's found in the K column. What I need is an addition for when the C column reads ALL the hours will be divided among all the people
    Last edited by cDEVNEWB; 12-09-2019 at 06:33 PM. Reason: additional info

  10. #10
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Nested IF function - dont know where to start

    How do I know who "all the people" are? Are they the craftsman in C through I on one row? I see ALL as an option in C, E, G and I but not D, F, or H. Does one ALL in C or E count or do they all have to be ALL? What exactly should the results be? Can you provide examples, what if C4 is ALL but E4 isn't? And how are the hours being divided between the people, if only one cell has ALL is that it... the number of hours would be divided by 1?

  11. #11
    Registered User
    Join Date
    12-04-2019
    Location
    Sweetwater, Texas
    MS-Off Ver
    365
    Posts
    8

    Re: Nested IF function - dont know where to start

    Here is how the form works. When a craftsman is selected in column C,E,G, or H the hours listed in column J are transferred over into column R/S. If more than one craftsman is selected, The formula in column K will divide the hours from J evenly between the number of craftsmen selected and transfer into R/S.

    What I need is a way to get the hours for the job selected to divide evenly between all the craftsmen when ALL is selected in column C.

    Hope that makes more sense.

  12. #12
    Registered User
    Join Date
    12-09-2019
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2016
    Posts
    9

    Re: Nested IF function - dont know where to start

    Try this. I believe it will do what you want.

    Cheers
    Attached Files Attached Files

  13. #13
    Registered User
    Join Date
    12-04-2019
    Location
    Sweetwater, Texas
    MS-Off Ver
    365
    Posts
    8

    Re: Nested IF function - dont know where to start

    Yeah it does. thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 01-05-2019, 03:33 AM
  2. [SOLVED] Help with IF, Nested IF and Vlookup! I dont know where to start
    By mookiebar in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-15-2017, 04:31 PM
  3. [SOLVED] Macro: Hide Row If Two Cells Dont Start The Same
    By excel2425 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-20-2016, 03:31 PM
  4. Dont even know where to start, maybe an if??
    By burnsie in forum Excel General
    Replies: 8
    Last Post: 02-20-2015, 08:15 AM
  5. Why dont we start discussion on renewable Energy sources?
    By synodbio in forum The Water Cooler
    Replies: 22
    Last Post: 12-18-2013, 05:45 AM
  6. Replies: 1
    Last Post: 12-14-2009, 05:20 PM
  7. Replies: 6
    Last Post: 10-31-2008, 11:52 AM

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