Number of equal groups given a total amount

[traceyonley777]

Hi all,

I'm new here and although I can find my way around excel ok I am really stuck on this.

I need a formula that can solve this problem (and otherslike it)

For example.

I have 37 apples. 1 box holds 24 apples. I need to know how many boxes of apples I have and how many apples are left over.

Can anyone help me with this?

I hope so.

Thank you in advance for your time.

[Special-K]

Erm this is just simple maths

Number of boxes would be

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

[NBVC]

=INT(A1/B1) gives total full boxes.

=A1-B1*INT(A1/B1) gives remainder

where A1 contain number of apples, and B1 contains number of apples 1 box holds.