MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### How do I round up numbers when dividing?

• Follow

```What I am doing is in regards to money. I am dividing an amount between two
people and sometimes the amount can't be divided equally so I want to be able
to have the formula automatically adjust.

So for instance: \$5000.23 divided by 2 does not divide equally.
So person A should get    \$2500.12
and person be should get \$2500.13

The same thing goes for \$523.00

Thanks.
```
 0
Reply Utf 12/16/2009 10:11:01 PM

```> So for instance: \$5000.23 divided by 2 does not divide equally.
> So person A should get    \$2500.12
> and person be should get \$2500.13

If the total amount is in A1 and you want Person A and Person B amounts in
B1 and C1 respectively, then:

B1:  =ROUND(A1/2,2)

C1:  =A1 - B1

Note:  When working with dollars-and-cents amount, it is always prudent to
round explicitly to avoid anomailies due to the way Excel does arithmetic.
So C1 should actually be =ROUND(A1-B1,2).

----- original message -----

"girlieinsd" wrote:

> What I am doing is in regards to money. I am dividing an amount between two
> people and sometimes the amount can't be divided equally so I want to be able
> to have the formula automatically adjust.
>
> So for instance: \$5000.23 divided by 2 does not divide equally.
> So person A should get    \$2500.12
> and person be should get \$2500.13
>
> The same thing goes for \$523.00
>
> Thanks.
```
 0
Reply Utf 12/16/2009 10:24:02 PM

```5000.23 divided by 2 will always return 2500.12  when set to 2 decimal
places.

Give Person B a penny from your pocket.

530.00 divided by 2  returns  265.00 so won't cost you anything from your
pocket.

Gord Dibben  MS Excel MVP

On Wed, 16 Dec 2009 14:11:01 -0800, girlieinsd
<girlieinsd@discussions.microsoft.com> wrote:

>What I am doing is in regards to money. I am dividing an amount between two
>people and sometimes the amount can't be divided equally so I want to be able
>to have the formula automatically adjust.
>
>So for instance: \$5000.23 divided by 2 does not divide equally.
>So person A should get    \$2500.12
>and person be should get \$2500.13
>
>The same thing goes for \$523.00
>
>Thanks.

```
 0
Reply Gord 12/16/2009 10:48:21 PM

2 Replies
420 Views

(page loaded in 0.073 seconds)

Similiar Articles:

7/31/2012 7:23:43 AM