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