If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
multiply # of pieces
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 |
#2
|
|||
|
|||
multiply # of pieces
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 |
#3
|
|||
|
|||
multiply # of pieces
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 |
#4
|
|||
|
|||
Correction
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 |
#5
|
|||
|
|||
Correction
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 |
#6
|
|||
|
|||
multiply # of pieces
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 -- 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 |
#7
|
|||
|
|||
Correction
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 |
Thread Tools | |
Display Modes | |
|
|