Solved

# Excel Pricing Calculator

Posted on 2012-08-30
259 Views
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.
0
Question by:ITworks

LVL 4

Author Comment

0

LVL 4

Accepted Solution

Nevermind.....I figured it out!
0

LVL 44

Expert Comment

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

0

LVL 4

Author Comment

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

LVL 4

Author Closing Comment

I figured it out by myself.
0

## Featured Post

### Suggested Solutions

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.