Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
IF(AND(A3="",B3=""),"",C2-A3+B3) should do the trick -- bill k ------------------------------------------------------------------------ bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821 View this thread: http://www.excelforum.com/showthread...hreadid=472349 |
#3
|
|||
|
|||
Thanks Bill, but unless I am doing something wrong, it doesn't work. -- deane1935 ------------------------------------------------------------------------ deane1935's Profile: http://www.excelforum.com/member.php...o&userid=27719 View this thread: http://www.excelforum.com/showthread...hreadid=472349 |
#4
|
|||
|
|||
For a running balance in Column C do this Assume you are putting your first formula in C4 and your carry-over or starting balance is in C3 =IF(AND(A4="",B4=""),"",C3-A4+B4) NOTE that you do not put negative numbers in your debit column (A), otherwise you'll be adding the debits instead of subtracting them. -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=472349 |
#5
|
|||
|
|||
Thanks Cutter, the = in front of IF made it work. -- deane1935 ------------------------------------------------------------------------ deane1935's Profile: http://www.excelforum.com/member.php...o&userid=27719 View this thread: http://www.excelforum.com/showthread...hreadid=472349 |
#6
|
|||
|
|||
You're welcome. And yes, the = is very important. It's what makes it a formula. Otherwise it's just a text string. -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=472349 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using contents of a cell in a formula | Excel Discussion (Misc queries) | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
looking for a formula | Excel Worksheet Functions |