Hello,
I'm looking for a formula to do the following, and have no idea how.
I have 3 main columns, A, B and C. Under each column I have 2 further columns, Boxes and Packs. One box contains 30 packs.
Under A I have 3 boxes and 15 packs. Under B I have 1 box and 25 packs. Under C I have 4 boxes and 5 packs.
At the end I have total, which I'd like to say how many full boxes I have and how many packs that do not make up a full box. Does that make sense?
So 3 boxes + 1 box + 4 boxes = 8...easy enough.
15 packs + 25 packs + 5 packs = 45 packs = 1 box and 15 packs.
This brings the total boxes to 9.
I'd like excel to display 9 boxes and 15 packs, no idea how to do this. Can be in 2 columns.
Does this make sense? Can anyone help?
Thanks!
Bookmarks