Excel formula with 03 sub qty

[Kalpesh123]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[TD]J
[/TD]
[TD]K
[/TD]
[TD]L
[/TD]
[TD]M
[/TD]
[TD]N
[/TD]
[TD]O
[/TD]
[TD]P
[/TD]
[TD]Q
[/TD]
[TD]R
[/TD]
[TD]S
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]SR.
[/TD]
[TD]PRODUCT
[/TD]
[TD]BAG
[/TD]
[TD]PKT
[/TD]
[TD]STRIP
[/TD]
[TD]PCS
[/TD]
[TD]QTY1
[/TD]
[TD]QTY2
[/TD]
[TD]QTY3
[/TD]
[TD]QTY4
[/TD]
[TD]QTY5
[/TD]
[TD]TOTAL QTY
[/TD]
[TD]BAG PCS
[/TD]
[TD]PKT IN BAG
[/TD]
[TD]STRIP
IN PKT
[/TD]
[TD]PCS IN STRIP
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]MD
[/TD]
[TD][/TD]
[TD]19 PKT
[/TD]
[TD]3 STRIP
[/TD]
[TD]8 PCS
[/TD]
[TD]380[/TD]
[TD]240
[/TD]
[TD]150
[/TD]
[TD]20
[/TD]
[TD]8
[/TD]
[TD]798[/TD]
[TD]960
[/TD]
[TD]24
[/TD]
[TD]4
[/TD]
[TD]10
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]FR
[/TD]
[TD]2 BAG
[/TD]
[TD]5 PKT
[/TD]
[TD][/TD]
[TD]9 PCS
[/TD]
[TD]180[/TD]
[TD]300
[/TD]
[TD]750
[/TD]
[TD]421
[/TD]
[TD]108
[/TD]
[TD]1759
[/TD]
[TD]750
[/TD]
[TD]15
[/TD]
[TD]5
[/TD]
[TD]10
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]3
[/TD]
[TD]SB[/TD]
[TD][/TD]
[TD]11 PKT
[/TD]
[TD]2 STRIP
[/TD]
[TD][/TD]
[TD]250
[/TD]
[TD]210
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]460
[/TD]
[TD]600
[/TD]
[TD]15
[/TD]
[TD]4
[/TD]
[TD]10
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I want formula for C,D,E,F

 

[FormR]

Dear Sir i want formula for cell C

If the formulas in post#4 and custom formatting in post#8 don't work for you then you need to explain why so alternatives can be offered.

 

[Kalpesh123]

thank you

 

[Kalpesh123]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[TD]P[/TD]
[TD]Q[/TD]
[TD]R[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]SR.[/TD]
[TD]PRODUCT[/TD]
[TD]BAG[/TD]
[TD]PKT[/TD]
[TD]STRIP[/TD]
[TD]PCS[/TD]
[TD]QTY1[/TD]
[TD]QTY2[/TD]
[TD]QTY3[/TD]
[TD]QTY4[/TD]
[TD]QTY5[/TD]
[TD]TOTAL QTY[/TD]
[TD]BAG PCS[/TD]
[TD]PKT IN BAG[/TD]
[TD]STRIP
IN PKT[/TD]
[TD]PCS IN STRIP[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]MD[/TD]
[TD][/TD]
[TD]19 PKT[/TD]
[TD]3 STRIP[/TD]
[TD]8 PCS[/TD]
[TD]380[/TD]
[TD]240[/TD]
[TD]150[/TD]
[TD]20[/TD]
[TD]8[/TD]
[TD]798[/TD]
[TD]960[/TD]
[TD]24[/TD]
[TD]4[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]FR[/TD]
[TD]2 BAG[/TD]
[TD]5 PKT[/TD]
[TD][/TD]
[TD]9 PCS[/TD]
[TD]180[/TD]
[TD]300[/TD]
[TD]750[/TD]
[TD]421[/TD]
[TD]108[/TD]
[TD]1759[/TD]
[TD]750[/TD]
[TD]15[/TD]
[TD]5[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]3[/TD]
[TD]SB[/TD]
[TD][/TD]
[TD]11 PKT[/TD]
[TD]2 STRIP[/TD]
[TD][/TD]
[TD]250[/TD]
[TD]210[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]460[/TD]
[TD]600[/TD]
[TD]15[/TD]
[TD]4[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I want formula for C,D,E,F

I have 4 type packing in my products 1 main packing and 3 sub packing
main pack is =Bag
2nd pack is =Pkt
3rd pack is =Strip
4th pack is =Pcs
i want formula for get result in all qty
in cell G4 QTY 1
in cell H4 QTY 2
in cell I4 QTY 3
in cell J4 QTY 4
in cell K4 QTY 5
in cell L4 =G4+H4+I4+J4+K4
in cell M4 is my main packing qty in pcs (pcs in main bag)
in cell N4 is my Sub packing (pcs in Pkt)
in cell O4 is my sub/sub packing (Strip in pkt)
in cell P4 is my sub/sub/sub Packing (pcs in Strip)
i know formula for 3 cell but i want formula for 4 cell
i used below formula now in 3 cell
D=TRIM(IF(L4>=N4,INT(L4/N4)&" Pkt ",""))
E=IF(MOD(L4,N4)>=P4,INT(MOD(L4,N4)/P4)& " Strip ","")
F==IF(MOD(L4,P4),INT(MOD(L4,P4))&" Pcs","")
i want forumal for cell C=

i.e
G2=380
H2=240
I2=150
J2=20
K2=8
L2=G2+H2+I2+J2+K2=798
M2=960PCS
N2=24PKT IN BAG
O2=4 STRIP IN PKT
P2=10PCS

RESULT IS
C2=
D2=19 PKT
E2=3 STRIP
F2=8PCS

I HAVE FORMULA FOR D2,E2,F2 BUT I DONT HAVE FORMULA TO GET RESULT IN C2

PLEASE GIVE ME FORMULA FOR CELL C2

 

[FormR]

PLEASE GIVE ME FORMULA FOR CELL C2

See post#4 or explain why the formula in post#4 does not work for you!

 

[Kalpesh123]

Update alredy mistake in cell number