Drop down formulas - pricing model

%3CLINGO-SUB%20id%3D%22lingo-sub-3350527%22%20slang%3D%22en-US%22%3EDrop%20down%20formulas%20-%20pricing%20model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3350527%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20somebody%20can%20help%20with%20this.%20We%20have%20a%20fairly%20complex%20pricing%20model%2C%20there%20are%20different%20packages%20and%20discounts%20available%20depending%20on%20the%20order%20quantity.%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20attempting%20to%20create%20a%20new%20excel%20worksheet%20containing%20drop%20down%20menus%20which%20allow%20the%20user%20to%20select%20different%20options%20to%20come%20to%20a%20final%20bill%20(the%20final%20version%20will%20be%20replicated%20on%20our%20website).%20There%20are%2012%20different%20initial%20orders%20numbers%20you%20can%20opt%20for%20-%2050%20orders%20per%20month%2C%20150%20orders%20per%20month%20200%20orders%20per%20month%2C%20250%20orders%20and%20so%20on%20up%20to%20600.%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20is%20an%20integration%20fee%2C%20which%20is%20discounted%20if%20you%20pay%20up%20front%20or%20an%20option%20to%20pay%20monthly%20which%20is%20the%20full%20cost%2C%20split%20over%2012%20months.%3CBR%20%2F%3E%3CBR%20%2F%3EThen%2C%20you%20have%20the%20option%20to%20sign%20up%20for%2012%2C%2018%2C%20or%2024%20months.%20If%20you%20choose%2018%20or%2024%20you%20get%20a%205%25%20or%208%25%20discount%20respectively.%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20is%20a%20further%20discount%20of%2012%25%20on%20top%20of%20that%20if%20you%20choose%20to%20pay%20your%20total%20order%20value%20for%20the%20duration%20of%20the%20contract%20up%20front%20rather%20than%20monthly%20for%20the%20length%20of%20the%20term.%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20really%20struggling%20to%20create%20a%20simple%20worksheet%20with%20drop%20down%20options%20that%20can%20handle%20these%20kinds%20of%20formulas%2C%20that%20gives%20a%20running%20total%20based%20on%20the%20options%20you%20choose%20above.%20I%20know%20this%20might%20be%20a%20bit%20much%20to%20ask%20on%20a%20forum%20but%20thought%20I'd%20give%20it%20a%20try!%20Thanks%20for%20reading%20this%20far......%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3350527%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi,

Hope somebody can help with this. We have a fairly complex pricing model, there are different packages and discounts available depending on the order quantity.

I'm attempting to create a new excel worksheet containing drop down menus which allow the user to select different options to come to a final bill (the final version will be replicated on our website). There are 12 different initial orders numbers you can opt for - 50 orders per month, 150 orders per month 200 orders per month, 250 orders and so on up to 600.

There is an integration fee, which is discounted if you pay up front or an option to pay monthly which is the full cost, split over 12 months.

Then, you have the option to sign up for 12, 18, or 24 months. If you choose 18 or 24 you get a 5% or 8% discount respectively.

There is a further discount of 12% on top of that if you choose to pay your total order value for the duration of the contract up front rather than monthly for the length of the term.

I'm really struggling to create a simple worksheet with drop down options that can handle these kinds of formulas, that gives a running total based on the options you choose above. I know this might be a bit much to ask on a forum but thought I'd give it a try! Thanks for reading this far......

0 Replies