Excel 2007 : Changing Quantity according to pack size

Please find the attached sheet to solve my problem.


Thanks

Please find the updated excel sheet to understand my query.

Hi Ben!

On the left I have the data.

PLU or product code 494 is appearing in cell A9 & A24.

Qty of 494 is 0.004 & 0.022.

This is a example of PENS in a box pack size of 6,12 & 24


Thanks

Navneet

Please find the attached file with comments in Output column.I am working in a Pen making factory.Each Pen Product code has a pack size.For example a box of pen will contain 12 pens or 6 pens.The pack size of each product code is mentioned in the excel sheet.


1.010 means 1 Box & 10 Pens

1.006 means 1 Box and 6 pens

0.010 means 10 Pens only


Waiting for a solution.Guys please help me.


Thanks

Thanks Davesexcel for the solution.Just one more thing I want.

Instead of writing the output in column M(Pen Box pack) & column N(pens).I cannot have the output like 1.002 in single column.

Thanks once again.

Thanks Buddy.

Hi USERS and specially Davesexcel.Another problem I am facing and I am really sure you will help me into that.I tried my best bf4 approaching you.

Please find the attached sheet to understand my requirement better.



Thanks in advance.

Thanks Davesexcel.Thanks alot.