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.