C Chip Pearson Jan 6, 2008 #3 See the ROUNDUP function. E.g., =ROUNDUP(0.1,0) returns 1 =ROUNDUP(5.111,0) returns 6. ROUNDUP moves away from zero, which is not necessarily the same as rounding toward positive. E.g., =ROUNDUP(-5.123,0) returns -6, not -5 -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site)
See the ROUNDUP function. E.g., =ROUNDUP(0.1,0) returns 1 =ROUNDUP(5.111,0) returns 6. ROUNDUP moves away from zero, which is not necessarily the same as rounding toward positive. E.g., =ROUNDUP(-5.123,0) returns -6, not -5 -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site)
