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)
|