Not a tough questions??

tttman

New Member
Joined
May 8, 2014
Messages
18
Basically I need to have a formula in rows 1-5 (45-49) that converts them from inches to pieces. The total at the bottom of each column would have a total of pieces.

For example row 45 would need the formula =A45*227. Rows 51, 52 dont need formulas because the user would enter pieces. However the end result at the bottom of the columns would need to be a total of pieces.

Thanks

Tyler

30xbpd3.jpg
[/IMG]
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

par60056

Well-known Member
Joined
Jul 26, 2012
Messages
1,581
Office Version
  1. 2011
  2. 2010
Platform
  1. Windows
  2. MacOS
If I am understanding you correctly, the value displayed for the formula is in pieces. If the user enters a value in 50 or 51 that number is in pieces so the appropriate formula would be =A50. Then you can sum the column to get total pieces.
 

tttman

New Member
Joined
May 8, 2014
Messages
18
If I am understanding you correctly, the value displayed for the formula is in pieces. If the user enters a value in 50 or 51 that number is in pieces so the appropriate formula would be =A50. Then you can sum the column to get total pieces.

The user would enter inches in lines 45-49...SO:

Line 45 User puts in 10...That 10 would have to be (sorry, screwed up) divided by 12 to get feet and then multiplied by 227 (pieces per foot)... so, 10(user added #)/12*227, also rounded = 189.6667 to 189

Line 45 10(user input inches)/12*227 = 189 which is rounded to the nearest whole #
Line 46 15(user input inches )/12*227 = 284 which is rounded to the nearest whole #


.
.
.
Line 50 User Inputs pieces here 100
Line 51 User Inputs pieces here 122



Total 695

I really tried to make this simple...
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,833
Office Version
  1. 2010
Platform
  1. Windows
B​
C​
D​
E​
45​
Inches
10​
46​
Inches
15​
47​
Inches
48​
Inches
49​
Inches
50​
Pieces
100​
51​
Pieces
122​
52​
Total Pieces
695​
D52: =SUMPRODUCT(ROUND(D45:D49/12*227, 0)) + SUM(D50:D51)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,827
Messages
5,855,877
Members
431,771
Latest member
CoryMelth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top