如何在Excel中使用Isblank函数的圆函数? [英] How to Use round function with Isblank function in Excel?
问题描述
我正在尝试使用isblank函数的round函数,但是当我复制公式时,我得到#value!如果没有价值;但是,如果我只使用isblank函数,那么就没有错误。我的代码在下面谢谢!
I am trying to use the round function with the isblank function but when I copy the formula down, I get #value! if there is no value; however if I use only the isblank function then there is no error. my code is below thanks!
=ROUND(IF(ISBLANK(D15),"",'Sheet2'!L25+'Sheet2'!P25+'Sheet2'!O25+AK15+AL15),0)
推荐答案
我的感觉是你遵循错误的顺序。尝试这样:
My feeling is that you followed the wrong order of things. Try this:
=IF(ISBLANK(D15),"",ROUND(Sheet2!L25+Sheet2!P25+Sheet2!O25+AK15+AL15,0))
另外, L42
可能适用于 D15
具有公式; ISBLANC
不检测由公式产生的空白。因此,考虑用 LEN(Trim(D15))= 0 替换
ISBLANK(D15)
code>。
Also the comment of L42
might be appropriate if the D15
has a formula; ISBLANC
does not detect blanks that result from formulas. Same if it actualy has spaces only, etc. For this reason consider replacing ISBLANK(D15)
with LEN(Trim(D15))=0
.
这篇关于如何在Excel中使用Isblank函数的圆函数?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!