The ROUNDUP and ROUNDDOWN functions in Microsoft Excel 2019

The ROUNDDOWN function rounds the number down to aspecified number of digits and always rounds down towards 0 (the lowestnumber). Open the file called Round-C.xlsx to see the formularesults, or try the formulas out using the Round.xlsxworkbook.

Type the formula, either ROUNDUP or ROUNDDOWN,directly into the answer cell. Or you can access the formula from theMath & Trig book located in theFunction Library.

The ROUNDUP function returns a number rounded up to thenext highest number.

Leave a Comment