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)

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)

Try this as the formula in G9:

=INT(F9/C3)

--
Biff
Microsoft Excel MVP


"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)

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)

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)