25860.9=25860 25861=25870 25869=25870More info needed. What version of Excel? What CELLS contain the source numbers? And, EXACTLY how have you entered the roundFUNCTION? COPY the functions from your cells for the 3 cases you stated in your post and PASTE them here.