Prev: Excel 2007 reformatting cells
Next: Your formuala also seems much simpler than mine.
From: girlieinsd on 16 Dec 2009 17:11
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.
From: Joe User on 16 Dec 2009 17:24
> 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.
From: Gord Dibben on 16 Dec 2009 17:48
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(a)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.

 | 
Pages: 1
Prev: Excel 2007 reformatting cells
Next: Your formuala also seems much simpler than mine.