Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-13-2018, 06:08 PM
baes10 baes10 is offline Keep balance column empty if no amount entered Windows 7 64bit Keep balance column empty if no amount entered Office 2007
Advanced Beginner
Keep balance column empty if no amount entered
 
Join Date: Dec 2017
Posts: 33
baes10 is on a distinguished road
Default Keep balance column empty if no amount entered

Hello, could you please help me with a formula in column G to hide the balance if no amount is enter in column D? I'd like the balance to appear if an amount is entered into column D as a new item. As of now, the balance is showing through the entire column.
Thank you so much!


Steve
Attached Files
File Type: xlsx Resident PIF Account Record.xlsx (16.7 KB, 8 views)
Reply With Quote
  #2  
Old 08-13-2018, 07:47 PM
Logit Logit is offline Keep balance column empty if no amount entered Windows 10 Keep balance column empty if no amount entered Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

.
Paste in G7 and drag down the column :

Code:
=IF(D7="","",G6+C7-D7)
Reply With Quote
  #3  
Old 08-13-2018, 09:34 PM
baes10 baes10 is offline Keep balance column empty if no amount entered Windows 7 64bit Keep balance column empty if no amount entered Office 2007
Advanced Beginner
Keep balance column empty if no amount entered
 
Join Date: Dec 2017
Posts: 33
baes10 is on a distinguished road
Default

Thank you so much!!!!
Reply With Quote
  #4  
Old 08-14-2018, 06:31 AM
Logit Logit is offline Keep balance column empty if no amount entered Windows 10 Keep balance column empty if no amount entered Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

You are welcome.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF adjacent cell empty Copy from Other Column ChrisOK Excel Programming 8 03-08-2018 09:17 PM
Perform function when t-character is entered in Column-A SerenityNetworks Excel Programming 3 12-22-2017 09:24 AM
Keep balance column empty if no amount entered If a cell equals amount in column B. lawnphysics Excel Programming 1 01-16-2016 07:51 PM
Keep balance column empty if no amount entered Calculate amount of entered fields sp1d3r69 Excel 3 01-26-2015 07:35 AM
How to know the outstanding balance amount of a Loan? PRADEEPB270 Excel 1 01-07-2012 04:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft