Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRUDUCT 3 Pieces of Criteria | Excel Worksheet Functions | |||
add value of 4 cells, multiply by 3 subtract 72 multiply by 80% | Excel Discussion (Misc queries) | |||
Finding pieces of a value in a table | Excel Discussion (Misc queries) | |||
Finding pieces of a value in a table | Excel Discussion (Misc queries) | |||
how do i get a set of pieces from a given # with standard lengths | Excel Worksheet Functions |