How to Use round function with Isblank function in

Question

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)

Answer 1

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.