how to use two size thing one formula

[raji123]

Hi everyone its my problem down

I have two types of "rainpet"
rainpet 4m
rainpet 6m

when,
A1=length
A2=width
A3=numbers(1,2,3,..)
if A3=1 then rainpet is no need
if A3=2or above
then,
use of rain pet numbers= ROUNDUP(A1/6,0) for 6m rainpet
ROUNDUP(A1/4,0) for 4m rainpet

but problem is here
I have to use both size of rain pet adding +2m in length
for example
A1=30m
A2=5.4m (width is no matter)
A3=2
whole length=30m+2m=32m
when length is 32m
then I have to use 6m rainpet=4 pieces (when A3=3 then double,A3=4 Then triple ....continue)
4m rainpet=2 pieces (when A3=3 then double,A3=4 Then triple ....continue)

And when length is 10m +2m =12m then (no need 4m rainpet ) 6m rainpet is 2 piece is ok.

thanks

 

[Ottsel]

then I have to use 6m rainpet=4 pieces (when A3=3 then double,A3=4 Then triple ....continue)
4m rainpet=2 pieces (when A3=3 then double,A3=4 Then triple ....continue)

And when length is 10m +2m =12m then (no need 4m rainpet ) 6m rainpet is 2 piece is ok.

Sorry having a hard time understanding this section. Am I understanding the pieces and multiplication portion correctly?
See example:

Book1
	F	G	H	I
1	Num		Multi	Pieces
2	2m	=	times 1	2
3	3m	=	times 2	6
4	4m	=	times 3	12
5	5m	=	times 4	20
6	6m	=	times 5	30
7	7m	=	times 6	42
8	8m	=	times 7	56
9	9m	=	times 8	72
10	10m	=	times 9	90
11	11m	=	times 10	110
12	12m	=	times 11	132
13	13m	=	times 12	156
14	14m	=	times 13	182
15	15m	=	times 14	210
16	16m	=	times 15	240
17	17m	=	times 16	272
18	18m	=	times 17	306
19	19m	=	times 18	342
20	20m	=	times 19	380
21	21m	=	times 20	420
22	22m	=	times 21	462
23	23m	=	times 22	506
24	24m	=	times 23	552
25	25m	=	times 24	600
26	26m	=	times 25	650
27	27m	=	times 26	702
28	28m	=	times 27	756
29	29m	=	times 28	812
30	30m	=	times 29	870
Sheet1

Cell Formulas
Range	Formula
I2:I30	I2	=F2*H2

 

[raji123]

sorry my english is not good. so I cant explain my problem correctly but see this sheet you will understand パイプハウス.xlsx A B C D E F G 1 30 奥行(Length) 2 5.4 間口(width) 3 2 連棟（multi-built) 4 *we can change in yellow part. needed number 5 when A3 is 1 then C7 or C8 is 0 is ok 6 7 レインペット(rainpet)　６ｍ 6 個（piece） 8 レインペット(rainpet)　４ｍ 8 個（piece） 9 10 it is normally used roundup formula. 11 but,we need here is problem 12 13 レインペット(rainpet)　６ｍ 4 個（piece） 14 レインペット(rainpet)　４ｍ 2 個（piece） 15 16 we can add +2m in A1 then need this result 17 18 Sheet3 Cell Formulas Range Formula C7 C7 =ROUNDUP((A1+2)/6,0)*(A3-1) C8 C8 =ROUNDUP((A1+2)/4,0)*(A3-1)
**this value (C7*6)+(C8*4)=(A3+2 ) is wanted**

 

[Ottsel]

sorry my english is not good. so I cant explain my problem correctly but see this sheet you will understand パイプハウス.xlsx A B C D E F G 1 30 奥行(Length) 2 5.4 間口(width) 3 2 連棟（multi-built) 4 *we can change in yellow part. needed number 5 when A3 is 1 then C7 or C8 is 0 is ok 6 7 レインペット(rainpet)　６ｍ 6 個（piece） 8 レインペット(rainpet)　４ｍ 8 個（piece） 9 10 it is normally used roundup formula. 11 but,we need here is problem 12 13 レインペット(rainpet)　６ｍ 4 個（piece） 14 レインペット(rainpet)　４ｍ 2 個（piece） 15 16 we can add +2m in A1 then need this result 17 18 Sheet3 Cell Formulas Range Formula C7 C7 =ROUNDUP((A1+2)/6,0)*(A3-1) C8 C8 =ROUNDUP((A1+2)/4,0)*(A3-1)
**this value (C7*6)+(C8*4)=(A3+2 ) is wanted**

Trying to come up with a solution for C7 x 6 + C8*4 to equal Cell 'A3" + 2.

Here's the "if 1, then equal's zero" part.

Book1
	A	B	C	D
1	30	奥行(Length)
2	5.4	間口(width)
3	2	連棟（multi-built)
4		*we can change in yellow part. needed number
5		when A3 is 1 then C7 or C8 is 0 is ok
6
7		レインペット(rainpet) ６ｍ	6	個（piece）
8		レインペット(rainpet) ４ｍ	8	個（piece）
raji123

Cell Formulas
Range	Formula
C7	C7	=IF(A3>=2,ROUNDUP((A1+2)/6,0)*(A3-1),"0")
C8	C8	=IF(A3>=2,ROUNDUP((A1+2)/4,0)*(A3-1),"0")

 

[raji123]

Trying to come up with a solution for C7 x 6 + C8*4 to equal Cell 'A3" + 2.

Here's the "if 1, then equal's zero" part.

Book1
	A	B	C	D
1	30	奥行(Length)
2	5.4	間口(width)
3	2	連棟（multi-built)
4		*we can change in yellow part. needed number
5		when A3 is 1 then C7 or C8 is 0 is ok
6
7		レインペット(rainpet) ６ｍ	6	個（piece）
8		レインペット(rainpet) ４ｍ	8	個（piece）
raji123

Cell Formulas
Range	Formula
C7	C7	=IF(A3>=2,ROUNDUP((A1+2)/6,0)*(A3-1),"0")
C8	C8	=IF(A3>=2,ROUNDUP((A1+2)/4,0)*(A3-1),"0")

Thank you for reply this formula is too near solve my problem, and hope that "C7"*6+"C8"*4="A3"+2 will come out.

 

[Ottsel]

Could you provide a list of some more examples?
So far I see:

Example: 1
A1 = 30
A2 = 5.4
A3 = 2
Answer: 6m = '4' & 4m = '2'

Example: 2
A1 = 10
A2 = 5.4
A3 = 2
Answer: 6m = '2' & 4m = '0'

I don't think this is correct, but thought I'd share:

Book1
	A	B	C
1	30.0m	奥行
2	5.4m	間口
3	2.0m	連棟
4
5		レインペット 6m	4 個
6		レインペット 4m	2 個
raji123

Cell Formulas
Range	Formula
C5	C5	=IF($A$3>=2,ROUNDUP(($A$1+$A$3)/$B5,0)*($A$3)/3,"0")
C6	C6	=IF($A$3>=2,ROUNDUP(($A$1+$A$3)/$B6,0)*($A$3)/8,"0")

 

[raji123]

Yes sure-:
Example1
A1=6m
A2=5.4m
A3=2
Answer: 6m = '0' & 4m = '2'
Example2
A1=8m
A2=5.4m
A3=2
Answer: 6m = '1' & 4m = '1'
Example3
A1=10m
A2=5.4m
A3=2
Answer: 6m = '2' & 4m = '0'
Example4
A1=12m
A2=5.4m
A3=2
Answer: 6m = '1' & 4m = '2'
Example5
A1=14m
A2=5.4m
A3=2
Answer: 6m = '2' & 4m = '1'
Example6
A1=16m
A2=5.4m
A3=2
Answer: 6m = '3' & 4m = '0'
.
.
.
.

Example7
A1=20m
A2=5.4m
A3=2
Answer: 6m = '3' & 4m = '1'

Example7
A1=30m
A2=5.4m
A3=2
Answer: 6m = '4' & 4m = '2'

Example8
A1=40m
A2=5.4m
A3=2
Answer: 6m = '7' & 4m = '0'

like this....

"I think if "A1"+2 is divide by 6 then, (4m=0) 4m rainpet is no need"