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)
See Question&Answers more detail:os