Excel Pricing Calculator

Posted on 2012-08-30
Last Modified: 2012-09-04
I'm creating a pricing calculator and have ran into a problem.  On the tab called STUD PRICE CALCULATOR, I want my users to enter the quantity, choose a diameter from a pull down list and enter the length.  Then I want the formula to calculate the price per piece and Weight.  I have the weight working correctly, but I can't get the formula to calculate the piece price correctly.  All of the calculations are performed on the tab marked CALCULATION.  On the calculation tab, you can get the piece price listed in ROW 10 under the corresponding column.  THe price is calculated based on the quantity and length of the part and it does some rounding and such.  Currently, if you go to the STUD PRICE CALCULATOR tab and enter a quantity of 44, diameter of 7/8-9 and length of 8.50" you get a piece price of $11.67.  But if you change it to 44" you get the same piece price because it is gettting the information from Sheet!Calculation, G10...but it's not doing the calculating.
Question by:ITworks
    LVL 4

    Author Comment

    LVL 4

    Accepted Solution

    Nevermind.....I figured it out!
    LVL 44

    Expert Comment

    by:Martin Liss
    I entered 44 and got this. What if anything should be different? Do you have automatic calculation sdet in Tools|Options?

    What's wrong?
    LVL 4

    Author Comment

    It wasn't working on one of the sizes (7/8-9) because the cell was renamed....
    LVL 4

    Author Closing Comment

    I figured it out by myself.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now