Hiding values in cells Solved

  1.    #1

    Hiding values in cells


    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
    Click image for larger version. 

Name:	Capture.PNG 
Views:	15 
Size:	11.2 KB 
ID:	222629
      My ComputerSystem Spec

  2.    #2

    Sven1458 said: View Post
    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
    Click image for larger version. 

Name:	Capture.PNG 
Views:	15 
Size:	11.2 KB 
ID:	222629
    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:
    =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.
      My ComputerSystem Spec

  3.    #3

    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
      My ComputerSystem Spec

  4.    #4

    Sven1458 said: View Post
    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
    Glad it worked for you. Excel is such an amazing product, it’s so versitile.
      My ComputerSystem Spec


 

Related Threads
I'm not sure this is a Window's problem/issue, but hopefully someone here can help out... Basically, when I edit the Album info in the metadata, it deletes all the other metadata. I bought the new 50th anniversary Beatles White Album. All 6...
MS Excel - Sorting text cells in Microsoft Office and 365
I am entering stamp collection catalogue "numbers" in a spreadsheet column. However, I am having problems sorting the stamps properly. For example: stamps 1, 2, 3, 1a, 2a, 3a should be sorted as 1, 1a, 2, 2a, 3, 3a. I know I am doing something...
DisableAntiSpyware vs DisableAntiVirus Values?? in AntiVirus, Firewalls and System Security
Does anyone know what the difference is between the DisableAntiSpyware vs DisableAntiVirus values for Windows 10 Defender? I know that in the past you only needed to set the "DisableAntiSpyware = 1" value in order to disable Windows Defender. But...
Hello, At our school, we are using Windows 10 but our computers are running slower and slower because it install useless apps during welcome screen and taking up space. i had found out that there was 51 users logged in in 1 computer and some...
FYI - Here are hash values and size for new build 10061 ISO in .WIM format.... ================================================== Filename : en_windows_10_pro_10061_x64_dvd .iso MD5 : c5d25d88baba25f7e4195a097477b8d7...
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 08:48.
Find Us