Try:

=IF(D2="","",D2-E2)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Michael Higgins" wrote in message
om...
Hi, i am `trying to find the auto function to allow column G to get the
outstanding balance due from the column D after the deposit has been
taken.

Many thanks.


Michael.

A B C D E F G
H I
DATE INVOICE NAME TOTAL DEPOSIT TYPE BALANCE DATE REF
NO:
21/6/08 1111111 smith 200 100 cash
100