How do I round up numbers when dividing?

[girlieinsd]

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.

 

[Joe User]

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

 

[Gord Dibben]

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