how to display answer as whole number and remainder
You can use MOD() to find the remainder.
Tim
"ynot" wrote in message
...
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
|