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

Try:

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

--
HTH

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

(E-Mail Removed)
Replace @mailinator.com with @tiscali.co.uk


"Michael Higgins" <(E-Mail Removed)> wrote in message
news:A1d7k.13484$(E-Mail Removed)...
> 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
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Try:
>
> =IF(D2="","",D2-E2)
>
> --
> HTH
>
> Sandy
> In Perth, the ancient capital of Scotland
> and the crowning place of kings
>
> (E-Mail Removed)
> Replace @mailinator.com with @tiscali.co.uk
>
>
> "Michael Higgins" <(E-Mail Removed)> wrote in message
> news:A1d7k.13484$(E-Mail Removed)...
>> 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
>>
>
>

Yes. When you select a cell you will see a small black square in the bottom
right-hand corner of the cell. Hover the cursor over this square and the
big white cross cursor will turn into small crosshairs. With the crosshairs
showing, left click and hold the button pressed while you drag the cursor
down the column. The formula will be copied and the cell references will be
indexed as you drag down. The small square is called the fill handle.

--
HTH

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

(E-Mail Removed)
Replace @mailinator.com with @tiscali.co.uk


"Michael Higgins" <(E-Mail Removed)> wrote in message
news:6Yd7k.13521$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Try:
>>
>> =IF(D2="","",D2-E2)
>>
>> --
>> HTH
>>
>> Sandy
>> In Perth, the ancient capital of Scotland
>> and the crowning place of kings
>>
>> (E-Mail Removed)
>> Replace @mailinator.com with @tiscali.co.uk
>>
>>
>> "Michael Higgins" <(E-Mail Removed)> wrote in message
>> news:A1d7k.13484$(E-Mail Removed)...
>>> 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
>>>
>>
>>
>
>