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