This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi Folks,
I'm in Excel tracking deductions from a total, but would like to have the formula cells (on the right) blank when there isn't a number in the cell on the left yet. I've tried a few different things but to no avail and would appreciate assistance! Thanks, David
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Thank you for the screenshots.
In the cell that contains the =E2 - D3 formula
Enter this formula and press Enter:
=IF(D3="","",E2 - D3)
Then select that cell and at the bottom right is a + fill handle, use that to drag down and fill the other cells in column E
Yes, that did it, thank you Dave!
Thank you from one David to another! So as you can hopefully see now (I couldn't attach screeenshots here earlier) I'm inputting data into Column D and want Column E to be empty in cells where there isn't data in Column D
Hi, I am Dave, I will help you with this.
Please provide a screenshot of your spreadsheet, select one of the cells on the right which contains the formula you are using so I can see your existing formula and please indicate which cell on the left may not contain data.