Hi all,
I have drawn a blank on how to hide cells that are empty, as in no data to display.
I set up the formula and it calculates properly, but if it gets to an empty cell, it will continue to display the results from the previous cell all the way to the bottom of the sheet, see picture below.
Would like some help in hiding the cells that don’t have any data yet. I have done that before, but can’t remember how I did it.
Thanks
Sven
Hi Sven1458. Here is how to do it. Assuming the the Credit Column is "F" and the Debit Column is "G" and the Balance Column is "H" ans the last row (with 1,000.00) in it is "50" then the formula you want to put in the Balance cell is:Hi all,
I have drawn a blank on how to hide cells that are empty, as in no data to display.
I set up the formula and it calculates properly, but if it gets to an empty cell, it will continue to display the results from the previous cell all the way to the bottom of the sheet, see picture below.
Would like some help in hiding the cells that don’t have any data yet. I have done that before, but can’t remember how I did it.
Thanks
Sven
=IF(AND(ISBLANK(F50),ISBLANK(G50)),"",OFFSET(H50,-1,0,1,1)-F50+G50)
what this formula says is:
if the two cells to the left are empty then the subject cell is blank, if not then it is equal to the algebraic sum of the cell immediately above and any credit or deposit to the left.
Be sure to copy the formula correctly. Let me know how it works for you.
SoFine406,
Thanks, that did the trick, I did find the "ifblank" syntax, but I get confused with all the """ and (())and ,,
Thanks again great job
Sven
PS> I think I need to take a refresher course in Spreadsheet programming. It has been a while
Quote