If I have this problem:
I have 37 apples. 1 box holds 24. I need to know how many boxes I have and how many apples are left over.
I had this answer:
total apples divided by how many a box can hold = 37 / 24, 1.5416666, as an integer = 1
remainder would be total apples - number of boxes used * 24 = 37 - 1*24 = 13
So A1 is total apples
B1 is boxes = INT (A1 / 24)
C1 is remainder = A1 - B1 * 24
But what exactly do I write as the formula inthe cell as these don't seem to work.
Thanks for your time.
Bookmarks