Excel Pull-sheet --- Cases out (PLUS) remaining bags ??

[Legacy 282493]

Hello,

This is my first post, any help would be greatly appreciated.

I create pull-sheets in excel everyday for 9,000+ orders. I have various different skus using (10) items. So at the bottom of the pull-sheet in order to help my warehouse dept, I have made formulas to tell them exactly what to pull...

For example:
(20) Chicken needs ---- COLUMN B "Total Bags Needed" (305) // COLUMN C "Cases" (12.708333)

I would like take the decimal in cases to a third column, COLUMN D to individual bags to pull.

So in a perfect world I would love to see:

COLUMN B "Total Bags Needed" (305) // COLUMN C "Cases" (12) // COLUMN D "Bags" (17)

I feel like there is an easy solution for this, I am just unable to "see it"

Thanks for your help!!

 

[ChrisM]

Well, =INT(C1) will give you just the integer portion of 12.708

Then =C1 - INT(C1) will give you the remaining decimals

You haven't listed your units/case/bag conversion factors so I'm not sure how to give you your desired answer.

 

[Legacy 282493]

I am able to get what I needed from using INT, thank you!!