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

how to display answer as whole number and remainder
 

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

how to display answer as whole number and remainder
 

Sorry, correction:
(although the formula before works, this one is cleaner)

a3: =TRUNC(A1/A2,0)

Hth

Carlo

"Carlo" wrote:

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

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