[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 297
  • Last Modified:

Excel Pricing Calculator

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
ITworks
Asked:
ITworks
  • 4
1 Solution
 
ITworksAuthor Commented:
0
 
ITworksAuthor Commented:
Nevermind.....I figured it out!
0
 
Martin LissOlder than dirtCommented:
I entered 44 and got this. What if anything should be different? Do you have automatic calculation sdet in Tools|Options?

What's wrong?
0
 
ITworksAuthor Commented:
It wasn't working on one of the sizes (7/8-9) because the cell was renamed....
0
 
ITworksAuthor Commented:
I figured it out by myself.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now