如果公式的一部分为空,则返回空白 [英] Returning blank if part of the formula is blank
问题描述
我需要什么可能是一个简单的公式,但在这个时候我不在我身边。我的公式就像= I9-F9。但是,如果F9为空,我希望结果的单元格保持空白,而不是分数。
I need what is probably a simple formula, but eludes me at this time. My formula is simply something like =I9-F9. However if F9 is blank I want the cell with the results to remain blank as opposed to a fraction.
推荐答案
ISBLANK
通常返回 TRUE
,如果单元格 F9
包含返回的空白另一个公式的一部分。例如见下文
ISBLANK
generally returns TRUE
, if the cell F9
contains blank which is returned as part of another formula. For example see below,
我已经使用检查细胞 A1
的公式是 1
并打印在单元格
B1
中。单元格 B1
实际上似乎是一个空白单元格,但不是。见下文
I have used a formula to check if cell A1
is 1
and print ""
in cell B1
. The cell B1
actually seems to be a blank cell, but it is not. See below,
最好的检查方法你的情况下的空格是,
The best way to check for blanks in your case is to,
=IF(F9="","",I9-F9)
这篇关于如果公式的一部分为空,则返回空白的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!