Sum 12 boxes = One case

[Exodis]

Hey guys and gals, i have a quick question on how to set up a formula. My Wife is the "Cookie Mom" for my daughters Girl Scout troop. I'm trying to set her up a spread sheet that helps with totals of boxes sold at booths. There are 12 boxes in one Case. I want to have on her spread sheet how many cases and boxes are left. Example they sell 30 Boxes of cookies. I would like in the next cell to show 2.6 cases for 2 cases 6 boxes. Is there a way to do this or am i wishful thinking lol

[pike]

Hi Exodis
one way

Please Login or Register  to view this content.

[pike]

should have been

Please Login or Register  to view this content.

[Exodis]

I greatly appreciate the help Pike! One thing though, when i put 31 in the target cell, it came up with 2 Cases: 0 Boxes. How do i get it to say 2 Cases 7 Boxes. Thanks again for the assistance!

[pike]

Ive checked again and it works for me
in a1 = 31
a2=INT(A1/12) & " Cases : " & MOD(A1,12)& " Boxes"
result 2 cases : 7 Boxes

[Exodis]

Whoops, forgot to switch the second A1 to my target cell lol, thanks again For all the help!

[pike]

Hi Exodis
no problem thanks for posting