Excel formula 03 sub qty

Status
Not open for further replies.

Kalpesh123

New Member
Joined
Dec 30, 2018
Messages
22
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
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
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
 
Upvote 0
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?
 
Last edited:
Upvote 0
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
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,216,077
Messages
6,128,685
Members
449,463
Latest member
Jojomen56

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top