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
Last edited by Exodis; 02-06-2011 at 09:16 AM.
Hi Exodis
one way
Please Login or Register to view this content.
should have been
Please Login or Register to view this content.
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!
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
Whoops, forgot to switch the second A1 to my target cell lol, thanks again For all the help!
Hi Exodis
no problem thanks for posting
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks