+ Reply to Thread
Results 1 to 4 of 4

Nesting a IF statement and Sum with refenced data that involves drop downs (pick list)

  1. #1
    Registered User
    Join Date
    05-03-2019
    Location
    Melbourne, Australia
    MS-Off Ver
    MS 2010
    Posts
    3

    Nesting a IF statement and Sum with refenced data that involves drop downs (pick list)

    I need help of the following formula;

    Cell L279 is populated by a drop down list.

    Cell N279 has the start time
    Cell O279 has the finish time
    Cell P279 has the break time

    Cell U 279 calculates SUM(O279-N279)-P279

    I want the cell to also check if L279 is = blank.

    How do I nest the formula, taking into consideration the data in L279 is a drop down list of names.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Nesting a IF statement and Sum with refenced data that involves drop downs (pick list)

    You dont need SUM, you only need to SUM when you're summing more than one figure.

    O279-N279 results in one figure, so you dont need SUM

    This is simply

    O279-N279-P279

    For your solution

    IF(L279<>"",O279-N279-P279,"")
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    05-03-2019
    Location
    Melbourne, Australia
    MS-Off Ver
    MS 2010
    Posts
    3

    Re: Nesting a IF statement and Sum with refenced data that involves drop downs (pick list)

    Thanks for this. So I actually need to sum the total hours between start and finish, minus the break time. How do I add that to this formula?

  4. #4
    Registered User
    Join Date
    05-03-2019
    Location
    Melbourne, Australia
    MS-Off Ver
    MS 2010
    Posts
    3

    Re: Nesting a IF statement and Sum with refenced data that involves drop downs (pick list)

    ahhh it works!! Thanks a million Special-K

+ 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. Drop Down list dependent on 2 previous drop downs
    By mrkawht in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-16-2018, 02:39 PM
  2. Data validation-> pick from list value (drop down menu)
    By Roiho in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-20-2017, 04:45 PM
  3. Replies: 5
    Last Post: 03-02-2015, 02:32 PM
  4. Replies: 9
    Last Post: 10-25-2013, 12:13 AM
  5. [SOLVED] Combine 2 data sets into one list based on user selection in drop downs.
    By Sassy13 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-01-2013, 01:46 PM
  6. [SOLVED] Can't use two drop downs to determine what's in another field with my IF statement
    By llovetrain in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2012, 10:56 AM
  7. pick up a cell data from a drop-down combo list
    By voodoofox in forum Excel General
    Replies: 8
    Last Post: 02-28-2008, 04:47 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