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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"FloMM2" wrote:

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

"Mike Stewart" wrote:

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" wrote:

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

"Shane Devenshire" wrote:

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Mike Stewart" wrote:

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