PDA

View Full Version : Excel Spreadsheets: Rounding



camel61
March 14th 2017, 07:05 AM
For quick reference;
Int(y/x)*x rounds y to the lower x
(Int(y/x)+1)*x rounds y to the higher x
Int(y/x+0.5)*x rounds y to the nearer x