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))
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
.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…