View Single Post
  #4   Report Post  
Sandy Mann
 
Posts: n/a
Default

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)