Thread
:
auto subtract
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Michael Higgins
external usenet poster
Posts: 8
auto subtract
thanks for that Sandy it worked, is there some way of using the code on all
the lines without having to edit the row number each time
Michael
"Sandy Mann" wrote in message
...
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
Reply With Quote
Michael Higgins
View Public Profile
Find all posts by Michael Higgins