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.

> 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.

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.