#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
.
Paste in G7 and drag down the column : Code:
=IF(D7="","",G6+C7-D7) |
#3
|
|||
|
|||
Thank you so much!!!!
|
#4
|
|||
|
|||
You are welcome.
|
|
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 |
If a cell equals amount in column B. | lawnphysics | Excel Programming | 1 | 01-16-2016 07:51 PM |
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 |