In Excel, if you apply a formula to a column range, the result will be displayed as zero while the reference cells are blank in the formula. But in this case, I want to keep the cell empty when apply formula until the reference cell entered with data, if there are any tricks to handle it?
Actually, there is a formula that can help you to keep the formula cell empty until data entered in reference cells.
For instance, here to calculate the difference between column Value 1 and column Value 2 in column Differences, and you want to keep the cell blank if there are some blank cells in the column Value 1 and column Value2.
Select first cell that you want to place the calculated result, type this formula =IF(OR(ISBLANK(A2),ISBLANK(B2)), "", A2-B2), and drag fill handle down to apply this formula to the cells you need.
In the formula, A2 and B2 are the reference cells in the formula you want to apply, A2-B2 are the calculation you want to use.
Fill Blank Cell
|In some cases, you may want to fill the blank cell based on the above cell or below cell, you can apply Kutools for Excel's Fill Blank Cellss utility to quickly handle it.|
Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.
Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!
300 New Features for Excel, Make Excel Much Easy and Powerful: