# Not a tough questions??

#### tttman

##### New Member
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

[IMG]http://i60.tinypic.com/30xbpd3.jpg[/IMG]

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### par60056

##### Well-known Member
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
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
 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)

Replies
2
Views
48
Replies
3
Views
26
Replies
2
Views
67
Replies
5
Views
65
Replies
3
Views
64