View Single Post
  #1   Report Post  
deane1935
 
Posts: n/a
Default formula for blank cell


I have a spreadsheet to keep a running balance. I have a formula
=sum(c2,-a3,+b3). It is copied thru the speadsheet. It works fine
except the last balance is propagated to the end of the sheet. I would
like to be able to check col a and col b and if they are blank, make
col c blank. How can I do this and still keep my running balance when I
enter a debit in col a or a credit in col b? Thanks for any help. Deane


--
deane1935
------------------------------------------------------------------------
deane1935's Profile: http://www.excelforum.com/member.php...o&userid=27719
View this thread: http://www.excelforum.com/showthread...hreadid=472349