View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
chew
 
Posts: n/a
Default Last value in column.


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: http://www.excelforum.com/member.php...o&userid=33061
View this thread: http://www.excelforum.com/showthread...hreadid=534878