+ Reply to Thread
Results 1 to 2 of 2

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
    1

    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 Images Attached Images
    Last edited by cDEVNEWB; Yesterday at 05:31 PM.

  2. #2
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    5,920

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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