how to display answer as whole number and remainder

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Sorry, correction:
(although the formula before works, this one is cleaner)

a3: =TRUNC(A1/A2,0)

Hth

Carlo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number displayed as text difficulties 4
Whole numbers and remainders 2
Excel formula needed to round up a value to a whole number 5
Round to nearest whole number 5
max number in cell rest in other cell 1
Rolling over a Remainder 2
How do I calculate a check-digit in Excel? 5
How to get different base systems so letters will show up like hex system tia sal2 1

Back
Top