Simple math calculation - 50/50?

[Abi]

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)

 

[N Harkawat]

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

 

[Jason Morin]

Use this in G16:

=ROUND(G14/2,2)

HTH
Jason
Atlanta, GA

 

[Sandy Mann]

Abi,

Try

G16: =ROUND(G16/2,2)

G18: =G16-M7

HTH

Sandy

 

[JE McGimpsey]

Take a look at

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

One way:

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