how to display answer as whole number and remainder

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

You can use MOD() to find the remainder.

Tim

"ynot" <(E-Mail Removed)> wrote in message
news

D331B7C-DB13-487D-A5B7-(E-Mail Removed)...
>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
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
convert number to dozen showing remainder	hayescircus	Microsoft Excel New Users	0	17th Mar 2010 02:38 PM
Why int remainder=(int)(Math.DivRem(MaxValue, 2, out remainder)) is 5 where int MaxValue = 10!!!;	Alexander Gorbylev	Microsoft C# .NET	3	20th Sep 2007 11:14 AM
How do I set up the remainder to display in Excel?	=?Utf-8?B?Q29mZmVlY29jbzkzMA==?=	Microsoft Excel Misc	11	27th May 2006 11:43 AM
Divide number and add remainder in another cell	=?Utf-8?B?cmhvbjEwMQ==?=	Microsoft Excel Misc	4	30th Nov 2005 02:02 AM
Display list of business contacts ordered by remainder time	Lars Nussbaumer	Microsoft Outlook Contacts	4	13th Nov 2003 01:12 PM