The problem is rounding. Unless cells are formatted (in this case to three
decimal places) so that each may be equal you are never going to get it
right.

Regards.

Bill Ridgeway
Computer Solutions

"Amature Amy!" <Amature wrote in message
...
Amature here!
Expense amount = 1,370.25 in A1
Client #1 owes 1/2 = $685.13 (A2)
Client #2 owes 1/2 = $685.12 (A3)
if I put the formula =A1/2 in A2, it returns $685.125, and then when I go
to
formatting it rounds to $685.13 (Correct)
But then, using that same formula in A3, it gives me $685.13, when it
should
be $685.12.
In A3, I tried using the formula =A1-A2, but it's still returning $685.13.
Help please - thank you.