Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: excel formula not shown if the cells are empty

23 Jun 2015   #1
kf10

Win 7 home premium 32 bit
 
 
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
excel formula not shown if the cells are empty-cap.jpg  
My System SpecsSystem Spec
.
23 Jun 2015   #2
GokAy

Windows 7 Ultimate x64 SP1
 
 

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 System SpecsSystem Spec
23 Jun 2015   #3
Boozad

W7 Pro x64 SP1 | W10 Pro IP x64 | W8.1 Pro x64 VM | Linux Mint VM
 
 

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 System SpecsSystem Spec
.

23 Jun 2015   #4
kf10

Win 7 home premium 32 bit
 
 

thanks a lot Boozad

you solved my problem
My System SpecsSystem Spec
23 Jun 2015   #5
Boozad

W7 Pro x64 SP1 | W10 Pro IP x64 | W8.1 Pro x64 VM | Linux Mint VM
 
 

You're welcome.
My System SpecsSystem Spec
Reply

 excel formula not shown if the cells are empty




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Excel Formula
Hello Sir, Can you let me know the formula in Excel: I have a table as below: This table, At the column "A,Status" when i Put the word" Completed", it's will automatic put current Date to Column "B, Row 2". But i don't know after that when tomorrow arrived,at the column "B,Row 2",...
Microsoft Office
Format cells in excel 2007
I have a spreadsheet made in excel 2007. In one of the cells is a number with three zeros in front of it and one zero at the end. However it always drops the zeros and shows only the other numbers. I select the cell and click on "format cells", but there is nothing I see that will show all the...
Microsoft Office
Excel: How do I make some cells remain the same when pulling it down?
Been having some problems with excel getting it to behave like Iwanted, tried google around but so clueless as to what to call things that it makes it hard. What I want is for a cell formula to do as I want when I pull on the lower-right corner down. Normally it the adds 1 to every cell address,...
Microsoft Office
Excel Formula Help please...
This is probably very simple and I have got it working but it isn't working how I want it to work. I have created an Excel document to show my monthly payments of a bank loan. I have created 3 columns in the first column is the payment number, in the second column is the amount that the loan...
Microsoft Office
Delete empty cells in worksheet
I am a newbie to Excel and have created a small calculation worksheet. It only occupies a small section of the worksheet and I would like to know how to only show that part and not showing the empty cells. I am using Microsoft Office 2007. Thanks jack
Microsoft Office
Excel un password cells
Hi I have a excel sheet that some cells are password protected i have no idea what the password is any ideas how i can find the password or any software that will find it, so i can change the cell contents. Thanks
Microsoft Office


Our Sites

Site Links

About Us

Find 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 17:33.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App