Simple math calculation - 50/50?
 

G14: $1500.39 - Total Due

G16: =(G14/2) - 50% Deposit

G18: =(G16-G14) - Balance Remaining

When G14 is an even number - no prob. However, when it's an odd number as
above:
G16: = $750.20
G18: = $750.20

How can I get this to balance properly? (G16: $750.20 and G18: $750.19)

In cell G16 type
=round(G14/2,2)
That will fix G18

"Abi" wrote in message
...
G14: $1500.39 - Total Due

G16: =(G14/2) - 50% Deposit

G18: =(G16-G14) - Balance Remaining

When G14 is an even number - no prob. However, when it's an odd number as
above:
G16: = $750.20
G18: = $750.20

How can I get this to balance properly? (G16: $750.20 and G18: $750.19)

Use this in G16:

=ROUND(G14/2,2)

HTH
Jason
Atlanta, GA

-----Original Message-----
G14: $1500.39 - Total Due

G16: =(G14/2) - 50% Deposit

G18: =(G16-G14) - Balance Remaining

When G14 is an even number - no prob. However, when
it's an odd number as
above:
G16: = $750.20
G18: = $750.20

How can I get this to balance properly? (G16: $750.20
and G18: $750.19)

.

Abi,

Try

G16: =ROUND(G16/2,2)

G18: =G16-M7

HTH

Sandy
--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Abi" wrote in message
...
G14: $1500.39 - Total Due

G16: =(G14/2) - 50% Deposit

G18: =(G16-G14) - Balance Remaining

When G14 is an even number - no prob. However, when it's an odd number as
above:
G16: = $750.20
G18: = $750.20

How can I get this to balance properly? (G16: $750.20 and G18: $750.19)

Take a look at

http://www.mcgimpsey.com/excel/pennyoff.html

One way:

G16: =ROUND(G14/2,2)
G18: =G14-G16

In article ,
Abi wrote:

G14: $1500.39 - Total Due

G16: =(G14/2) - 50% Deposit

G18: =(G16-G14) - Balance Remaining

When G14 is an even number - no prob. However, when it's an odd number as
above:
G16: = $750.20
G18: = $750.20

How can I get this to balance properly? (G16: $750.20 and G18: $750.19)