But the OP didn't want that, hence ROUNDDOWN or INT is required.
--
David Biddulph

"Francis" wrote in message
...
try this in G9

=ROUND(F9/C3,0)

this will either round up or down to the nearest whole number
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"dbarc" wrote:

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)