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
G4=270
H4=90
I4=540
J4=105
K4=30
L4=G4+H4+I4+J4+K4=1035
M4=600PCS
N4=40PCS
O4=4 STRIP
P4=10PCS
RESULT IS
C4=1 BAG
D4=10 PKT
E4=3 STRIP
F4=5PCS
I HAVE FORMULA FOR D4,E4,F4 BUT I DONT HAVE FORMULA TO GET RESULT IN C4
PLEASE GIVE ME FORMULA FOR CELL C4