Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Trying to do a balance sheet in Ms Excel.?
I want a withdrawal column (C), a Deposit column (D) and a running Balance column (E).
The formula I am using in (E) is =IF(C19+D19<>0,
SUM(E18,D19-C19)).
But I want nothing to show in the Balance column (E) untill I have made an entry in either the Withdrawal column (C), or the Deposit column (D).
If I extend the formula down through the (E) column I get the word (False). How do I get rid of the word "False" and leave just a blank cell in (E).
E18 is the previous balance.Put, for example £500 in E18
3 Answers
- 1 decade agoFavorite Answer
Try using this, you need to tell the formula what to return when the condition is false, the "" before the final parenthesis denotes a text string containing no characters. You could for example place any text in between the quote (") marks.
Hence
=IF(C19+D19<>0,SUM(E18,D19-C19),"")
Will return a blank. But if you used
=IF(C19+D19<>0,SUM(E18,D19-C19),"Pancake Farmer")
It will return Pancake Farmer if there is no date in C19 and D19.
Source(s): 6 Years experience using MS Excel and Access to produce management information for HSBC, - 1 decade ago
=IF(C19+D19<>0,SUM(E18,D19-C19),"")
You left off the last clause of the IF statement so it returns FALSE as a default. Just enter double quotes like above to return an empty string.
- Anonymous1 decade ago
You're trying to make it too complicated. Assuming you have column headings in row 1 of c1 Withdrawals, d1 deposits and e1 Balance, and a starting balance figure in e2, and you start to put entries into row 3,why not simply put the formula=e2+(d3-c3)and replicate it down as a relative formula. Then go to Tools, Options, View and untick the Show Zero option so that nothing will appear in column d until you start entering data in columns c and d.
