+ Reply to Thread
Results 1 to 2 of 2

create a product calculator

  1. #1
    exceloldiebutnewbie
    Guest

    create a product calculator

    I am trying to create an in-house product calculator by means of a
    spreadsheet for in-house calculations of customizable products we offer. Our
    prices are determined by a base price plus whatever variables our customers
    request. Depending on the variables, the price will change. We cannot
    figure out how which function to use to set up such a calculation in a
    spreadsheet (i.e. item x cost $45.00, customer wants to add option A and
    option B. Option A costs an additional $10.00 and option B costs an
    additional $5.00. But let's say our variables are up to 30 different options
    with 10 to 15 customizable items. Is there such a function to us for
    something like this???).

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,345

    Dropdowns with lookup formulas

    http://www.excelforum.com/showthread...28#post1519628

    This is a similar post, you can adjust the example to meet your own requirements

    Also check out this sight for dependent dropdowns, you can also download a sample sheet there

    http://www.contextures.com/xlDataVal13.html

+ 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