开发者

Excel: How to keep some cells blank

I have an Excel spreadsheet to which I am adding data on an almost dai开发者_运维知识库ly basis. It is very simple--the variable just goes into the cells in column B and various formulas spit out results in subsequent columns. Here is the issues, in all of those other columns, I prefer that the columns remain blank until there is a number in the B cell. Right now, the formulas take an empty B cell as a 0 and go ahead a spit out a result. What can I do to keep those blank, even though the formula is there ready for data, until something is imputed?


You can use ISBLANK function + IF condition to achieve this.

=IF(ISBLANK(A3),"",A3+15)

This formula adds 15 to A3 only if A3 is not blank.


In your formula, you can check the value of column B:

=IF (B2 <> ""; B2 * 2; "")
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜