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.

Splitting an expense
 

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.

Splitting an expense
 

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

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.



--
Steve (3)

Splitting an expense
 

Hi,

Could you round up B1 and round down C1

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

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=564834

Splitting an expense
 

All you can do, is make a decision that the first company pays the rounded
up figure.
A2 = roundup(a1/2,2)

now a3 = a1-a2

Steve


On Tue, 25 Jul 2006 19:05:57 +0100, SteveW
wrote:

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

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.






--
Steve (3)