separate numbers that have a / between them
Thank you.....
"Fred Smith" wrote:
Say your inventory count is in a1, and your case size is in a2. Your item count
can be calculated as:
=A2*LEFT(A1,FIND("/",A1)-1)+RIGHT(A1,LEN(A1)-FIND("/",A1))
Your (decimal) case count would be the above / a2
--
Regards,
Fred
"widman" wrote in message
...
A software program I have generates all stock or movement in full/partial
format, so if I have 10 full cases and a case with 4 of 6 items in it, it
represents inventory as
10/4. A case of 200 might show 4/198 meaning 4 full and 198 loose. It does
the same for sales, inventory, etc.
How can I convert this into something usefull, like 10.67, or even rounded
to 11?
|