excel formula not shown if the cells are empty


  1. Posts : 469
    Win 7 home premium 32 bit
       #1

    excel formula not shown if the cells are empty


    i have excel file, with the following formulas

    Cell G2 formula =SUM(D2:F2)
    Cell G3 formula =SUM(G2, D3:F3)
    Cell G4 formula =SUM(G3, D4:F4)
    Cell G5 formula =SUM(G4, D5:F5)

    i want the result of G5 (and the rest of G cells) cells to be invisible unless there is some value in D5 to F5 cells

    please forgive my poor english
    Attached Thumbnails Attached Thumbnails excel formula not shown if the cells are empty-cap.jpg  
    Last edited by kf10; 23 Jun 2015 at 02:44.
      My Computer


  2. Posts : 5,656
    Windows 7 Ultimate x64 SP1
       #2

    I haven't used for a very long time but I guess you can accomplish this with a conditional cell formatting.
    Also belongs to the Office section. :)
      My Computer


  3. Posts : 6,741
    W7 Pro x64 SP1 | W10 Pro IP x64 | W8.1 Pro x64 VM | Linux Mint VM
       #3

    You'll need to enter the formula shown below (note the blank cell selected contains the formula yet remains blank). Amend the formula for each line using the relevant cell numbers.
    excel formula not shown if the cells are empty-capture.jpg
      My Computer


  4. Posts : 469
    Win 7 home premium 32 bit
    Thread Starter
       #4

    thanks a lot Boozad

    you solved my problem
      My Computer


  5. Posts : 6,741
    W7 Pro x64 SP1 | W10 Pro IP x64 | W8.1 Pro x64 VM | Linux Mint VM
       #5

    You're welcome. :)
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

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