Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dividing by fixed number | Excel Discussion (Misc queries) | |||
Dividing by unknown to get a number | Excel Worksheet Functions | |||
New installed Excel2003 keeps dividing any number entered in any . | Excel Discussion (Misc queries) | |||
What is the formula for dividing a number by 4 in excel | Excel Worksheet Functions | |||
number format keeps dividing by 100 | New Users to Excel |