how can i use a whole number after dividing?

[dbarc]

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)

 

[Rick Rothstein]

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

=INT(F9/C3)

and this in H9...

=MOD(F9,C3)

 

[T. Valko]

Try this as the formula in G9:

=INT(F9/C3)

 

[Francis]

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