Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to display answer as whole number and remainder
I wanted to be able to divide one number by another and display the answer as
a whole number (not rounded up or down) and then the remainder in separate cells so I can apply other formulas to the answers later. EG 6000 / 305 = 19 r 205 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert number to dozen showing remainder | New Users to Excel | |||
I need an answer display in one cell if (=), but another if (-) | Excel Discussion (Misc queries) | |||
Formulas display 0 instead of answer | Excel Discussion (Misc queries) | |||
How do I set up the remainder to display in Excel? | Excel Discussion (Misc queries) | |||
Divide number and add remainder in another cell | Excel Discussion (Misc queries) |