multiply # of pieces

[Mike Stewart]

I need to know how to make this work, Looking for the formula to to make it
calc the number of pieces.




CUSTOMER COST
# of pieces Width Hight Sq Ft Cost

50 100 34.7 20.49

Thanks
Mike

 

[Shane Devenshire]

Hi,

I'm not entirely sure what you want but here is my guess:

=B2*C2/D2

Assuming that your sample is in the range A2:E2

 

[FloMM2]

Mike,
If I understand what you have sent in.
Width and Height are in inches, so 50in x 100 in is then divided by 144 sq
in to get
34.72 sq ft. at a cost of $20.49.
To find the number of pieces, you would have to know the dimensions of one
(1) piece (in square feet) and divide 34.72 by that number to find out how
many pieces.
hth

 

[Mike Stewart]

I need the formula to make the sq multiply by a number i put in a4 example:
A1 A2 A3 A4 A5 A6
3 pieces 30 x 30 /144=sq ft x .50=dollar amount
I think I need A1 to multiply A4 by the amount of pieces I put in A1

Hope this helps
Mike

 

[FloMM2]

Mike,
This is what I came up with:
Cell A1 type "# of pieces"
Cell B1 type "Sq ft of piece"
Cell C1 type "Width"
Cell D1 type "Height"
Cell E1 type "# of Sq ft"
Cell F1 type "Cost"

In Cell A2 type "=ROUNDUP(D2/B2,0)"
Cell B2 type "3", this is if each piece is 3 sq ft.
Cell C2 type "30"
Cell D2 type "30"
Cell E2 type "=((C2*D2)/144)", this converts sq in to sq ft.
Cell F2 type "=(E2*0.50)", format this cell to currency.

This will calculate the number of pieces needed to cover the sq ft that is
calculated.
If the piece is not 3 sq ft, just change the value in cell B2, and the
formula will adjust.
hth Dennis

 

[Shane Devenshire]

Hi,

You are confusing the issue by listing the values on one row in your sample
data and then tellng us they are in a column. I think you also negelected to
tell us what units the width and height were measured in.

The formula for area, assuming the height and width are in inches and you
want square ft. And assuming that the data is layed out in a column as
follows and assuming the cost per square foot is $0.50
A
1 50
2 100
3 34.7
4 =A2*A3/144
5 =A4*A1*.5

 

[Shane Devenshire]

Hi FloMM2,

No need for the () in

=((C2*D2)/144) just =C2*D2/144
and
=(E2*0.50) just =E2*0.5

Multiplication and Division a distributive - that the math way of saying you
don't need the ()'s here.