Video on ROUND and MROUND in Excel
The ROUNDUP function is a great function. ROUNDUP always rounds number 1 to 9 up, compared to the ROUND function where numbers 5 and up are rounded up, and numbers 1 through 4 are rounded down.
The ROUNDUP function has two arguments, the cell reference and the number of decimals to round.
Number Formula Answer
285.34 =roundup(cell,0) 286.00
285.34 =roundup(cell,1) 285.40
285.342 =roundup(cell,2) 285.35
285.342 =roundup(cell,-1) 290.00
Chris Menard’s Website: