Excel formula 03 sub qty

[Kalpesh123]

1 box=600 pecs
1 box=15 pkt
1 box=4 strip

my total qty 1274

how to get qty in box/pkt/strip/pcs=2box,1pkt.3strip,4pcs

please suggest excel formula for this.

Thanks,
regards,
kalpesh

 

[Mentor82]

1 box=600 pecs
1 box=15 pkt
1 box=4 strip

my total qty 1274

how to get qty in box/pkt/strip/pcs=2box,1pkt.3strip,4pcs

please suggest excel formula for this.

Thanks,
regards,
kalpesh

Hi,
I've read your problem a couple of times but find it hard to understand what you're doing, what results you want to achieve and where's the problem that you face?
More details needed in order give you any recommendation.

Regards,
Sebastian

 

[MARK858]

As well as explaining your requirement better as per Mentor82's request (especially as it is not clear if you want it converted from or to 1274).

Can you not convert...

1 box=600 pecs
1 box=15 pkt
1 box=4 strip

to the number of pcs rather than the part of the box? i.e. 1 pkt = 20 pcs, 1strip = 150 pcs and work it out from there?
with a strip = 150 I don't see how 2box,1pkt.3strip,4pcs can be correct?

 

[Kalpesh123]

Hi,
I've read your problem a couple of times but find it hard to understand what you're doing, what results you want to achieve and where's the problem that you face?
More details needed in order give you any recommendation.

Regards,
Sebastian

1 BOX = 600 PCS
1 BOX = 15 PKT
1 PKT = 4 STRIP
1 PKT = 40 PCS

i.e.
A=290 PCS
B=100 PCS
C=350 PCS
D=132 PCS
E= 460 PCS
F= (A+B+C+D+E) = 1332 PCS

NOW I WANT CONVORT THIS QTY IN BOX/PKT/STRIP/PCS
i.e
G= BOX
H= PKT
I= STRIP
J= PCS

I WISH TO GET RESULT LIKE BELLOW
G=2BOX
H=3 PKT
I=1 STRIP
J=3 PCS

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...rmula-03-sub-qty-post5199615.html#post5199615
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).