software

Please could someone tell me how to do this:

Column G has Account Balance (eg. B3 = $100, B2 = $130, B4 = £150
etc.)

I need a formula that will subtract B3 from Bx to show my profit. (Bx
being the last balance entry.)

So when I enter a new balance the profit is automatically updated.

Thanks

Chew--
chew
------------------------------------------------------------------------
chew's Profile: www.excelforum.com/member.php...oamp;userid=33061
View this thread: www.excelforum.com/showthread...hreadid=534878=INDEX(B:B,COUNTA(B:B))-B3

HTH
--
AP

quot;chewquot; gt; a écrit dans le
message de ...
gt;
gt; Please could someone tell me how to do this:
gt;
gt; Column G has Account Balance (eg. B3 = $100, B2 = $130, B4 = £150
gt; etc.)
gt;
gt; I need a formula that will subtract B3 from Bx to show my profit. (Bx
gt; being the last balance entry.)
gt;
gt; So when I enter a new balance the profit is automatically updated.
gt;
gt; Thanks
gt;
gt; Chew
gt;
gt;
gt; --
gt; chew
gt; ------------------------------------------------------------------------
gt; chew's Profile:
www.excelforum.com/member.php...oamp;userid=33061
gt; View this thread: www.excelforum.com/showthread...hreadid=534878
gt;
Ardus,

Might be better as

=INDEX(B:B,COUNT(B:B))-B3

in case there is a text heading in column B.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Ardus Petusquot; gt; wrote in message
...
gt; =INDEX(B:B,COUNTA(B:B))-B3
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;chewquot; gt; a écrit dans le
gt; message de ...
gt; gt;
gt; gt; Please could someone tell me how to do this:
gt; gt;
gt; gt; Column G has Account Balance (eg. B3 = $100, B2 = $130, B4 = £150
gt; gt; etc.)
gt; gt;
gt; gt; I need a formula that will subtract B3 from Bx to show my profit. (Bx
gt; gt; being the last balance entry.)
gt; gt;
gt; gt; So when I enter a new balance the profit is automatically updated.
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; Chew
gt; gt;
gt; gt;
gt; gt; --
gt; gt; chew
gt; gt; ------------------------------------------------------------------------
gt; gt; chew's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33061
gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=534878
gt; gt;
gt;
gt;

Thanks Ardus

Chew--
chew
------------------------------------------------------------------------
chew's Profile: www.excelforum.com/member.php...oamp;userid=33061
View this thread: www.excelforum.com/showthread...hreadid=534878