For your example row, put this in G9...

=INT(F9/C3)

and this in H9...

=MOD(F9,C3)

--
Rick (MVP - Excel)


"dbarc" wrote in message
...
I need to take only the whole number portion of a result and use it to get
another answer, but my formula seems to use the whole answer. Example
C3=15,
f9=40. I divide f9 by c3 and get 2.666666 in g9. Now I need to display
the
remaining part of my answer as a whole number in cell h9. So my formula I
come up with is this =(f9-(g9*c3)). This alway gives me 0 as the answer.
I
need my worksheek to show 2 full baskets (heading of column g) and 10 each
(heading of col h)