+ Reply to Thread
Results 1 to 3 of 3

Addition/Subtraction with Menu Selection

  1. #1
    Registered User
    Join Date
    08-26-2008
    Location
    NY
    Posts
    18

    Addition/Subtraction with Menu Selection

    Included is an example of a spreadsheet I am working on. There are multiple choices within several different drop-down menu's. As of right now I have the 1st menu as the stage of completion of a car. Within the next few menu's are options.

    If welded chassis is chosen, none of these options are included. However if roller or turn-key are chosen then some of these options are included. But then there are also upgrades to these parts that are included as well. Is there a way to make 1 option included when a roller is chosen, but then if you want the 2nd option in the menu, you click on it and it automatically updates the price next to it, therefore subtracting the cost of option 1 from the cost of option 2?
    Attached Files Attached Files
    Last edited by slvr98svt; 01-09-2009 at 10:09 AM.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492
    Yes, I would move the "IF" statements out of the column C and over to the items themselves. Let the price cells for Rear Shock watch for the Car Type.

    If Welded Chassis, show full prices...660 and 750. If not, show "included" and $150, or whatever your upgrade price is.
    Same for Front Shocks.

    Then back in your original Rear Shock cell C10 & C13, remove the IF stuff and just let it do a normal HLOOKUP.

    Like attached.
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    08-26-2008
    Location
    NY
    Posts
    18
    Jbeaucaire, thank you. That will work just perfect! Now, to go through all my options and change all the cells!!!

    Thanks Again,
    -Matt

+ 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