Splitting an expense

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.

Hi,

Could you round up B1 and round down C1

B1 =ROUNDUP($A$1/2,2)
C1 =ROUNDDOWN($A$1/2,2)

VBA Noob

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 [email protected]> wrote in message
news:[email protected]...
> 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.

Why should A3 give a different answer to a2 ?

Anyway, each is getting 685.125 and yes when rounded using the 2decimal =
=

format they will both show 685.13

Keep the 1/2 cent - all the big corporations do

No simple way around this other than format cells with 3 decimal places

Steve



On Tue, 25 Jul 2006 18:56:02 +0100, Amature Amy! <Amature =

<[email protected]>> wrote:

> Amature here!
> Expense amount =3D 1,370.25 in A1
> Client #1 owes 1/2 =3D $685.13 (A2)
> Client #2 owes 1/2 =3D $685.12 (A3)
> if I put the formula =3DA1/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 =3DA1-A2, but it's still returning =

> $685.13.
> Help please - thank you.



-- =

Steve (3)

All you can do, is make a decision that the first company pays the round=
ed =

up figure.
A2 =3D roundup(a1/2,2)

now a3 =3D a1-a2

Steve


On Tue, 25 Jul 2006 19:05:57 +0100, SteveW <[email protected]> =

wrote:

> Why should A3 give a different answer to a2 ?
>
> Anyway, each is getting 685.125 and yes when rounded using the 2decima=
l =

> format they will both show 685.13
>
> Keep the 1/2 cent - all the big corporations do
>
> No simple way around this other than format cells with 3 decimal place=
s
>
> Steve
>
>
>
> On Tue, 25 Jul 2006 18:56:02 +0100, Amature Amy! <Amature =

> <[email protected]>> wrote:
>
>> Amature here!
>> Expense amount =3D 1,370.25 in A1
>> Client #1 owes 1/2 =3D $685.13 (A2)
>> Client #2 owes 1/2 =3D $685.12 (A3)
>> if I put the formula =3DA1/2 in A2, it returns $685.125, and then whe=
n 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 =3DA1-A2, but it's still returning =

>> $685.13.
>> Help please - thank you.
>
>
>



-- =

Steve (3)