+ Reply to Thread
Results 1 to 4 of 4

Drop down menu with multiple formulas

  1. #1
    Registered User
    Join Date
    07-31-2019
    Location
    Atlanta, GA USA
    MS-Off Ver
    MS Office for Mac 2011
    Posts
    2

    Drop down menu with multiple formulas

    Hi. Hopefully I can explain this properly. I've created a dropdown menu in column G with 4 options (Coke with Buyout, Coke w/o Buyout, Non-Coke with Buyout and Non-Coke w/o Buyout. Column K will populate totals based on numbers in column E, H and J and whatever is selected from my dropdown menu in column G.

    The formula below works beautifully until I need to divide the totals by 2 or 50%. I want the totals to be (E:E-H:H-J:J)/2 and (E:E-J:J)/2 and (E:E-H:H)/2 and E:E/2 but I can't figure out how to include division into all the equations so that it works. E:E/2 is the only one that works.

    =IF(G:G="Coke with Buyout",E:E-H:H-J:J,IF(G:G="Coke w/o Buyout",E:E-J:J,IF(G:G="Non-Coke with Buyout",E:E-H:H,IF(G:G="Non-Coke w/o Buyout",E:E/2))))

    Any help is much appreciated.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Drop down menu with multiple formulas

    Are you sure that formula is working for you? Your syntax is all out or wack - so maybe it's just coincidence that it is working on a few?

    IF statements, in the way you are using them, take a single cell ref, not a range...
    =IF(G:G="Coke with Buyout...
    =IF(G2="Coke with Buyout..........
    etc

    Perhaps you should upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    07-31-2019
    Location
    Atlanta, GA USA
    MS-Off Ver
    MS Office for Mac 2011
    Posts
    2

    Wink Re: Drop down menu with multiple formulas

    Actually cleaning up the columns from G:G to G4, etc. allowed me to add the additional equation I needed. I made something simple into difficult overthinking. Spreadsheet was ready in time for my meeting today. Thanks so much!!!

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Drop down menu with multiple formulas

    Always great when you fix it yourself And simple is almost always best. Thanks for the feedback

+ 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: 0
    Last Post: 02-10-2015, 05:17 PM
  2. [SOLVED] help on drop down menu's, If and data range formulas
    By Rellsunn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-05-2015, 02:43 PM
  3. [SOLVED] Drop Down Menu Formulas
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 01-26-2015, 04:29 AM
  4. Drop Down Menu Formulas
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-23-2015, 05:51 PM
  5. Options in Drop Down Menu to choose from different formulas.. I think...
    By oscarcarl in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-15-2015, 07:58 PM
  6. [SOLVED] Formulas Based on results from a drop down menu
    By bramdana in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-03-2014, 01:29 AM
  7. Replies: 1
    Last Post: 11-14-2011, 02:48 PM

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