Hi ynot

do you want to have this in VBA or as a formula?

formula:
a1: 6000
a2: 305
a3: =ROUND((A1-(A2/2))/A2,0)
a4: =A1-A2*A3

hth

Carlo

"ynot" wrote:

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