Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto subtract
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto subtract
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtract | Excel Worksheet Functions | |||
How do I get "auto sum" to subtract hidden cell values from total | Excel Worksheet Functions | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
How do I add to one cell and auto subtract from another in Excel? | Excel Discussion (Misc queries) | |||
Add IF or Subtract IF?? | Excel Worksheet Functions |