The INT and ROUND functions in Microsoft Excel 2019

The INT function rounds a number down to the nearestinteger. The INT function does not round off to the nearestwhole number; only the decimals are removed, and the number without thedecimals is used in calculations. For example, =INT(95.77) isdisplayed and stored in memory as 95. To follow each ofthese examples explained in this topic, openthe Round.xlsx workbook (to try the formulas yourself), oralternatively, the completed workbook, Round-C.xlsx.

It is also possible to insert the INT function before aformula so that the formula answer is an integer. An example of thistype of formula would be =INT(sum(C45:C55)).

In the workbook, look at the data to the right of the worksheet. Thefirst table shows the SUM formula result withoutINT, and the second table displays the SUM formulawith the INT functionapplied: =INT(SUM(N11:N13)). Double-click on cellN14 to see the INT formula.

The ROUND function is also a mathematical function thatrounds the value off to a certain number of decimal places. TheROUND function rounds up or down, depending on whether thedigit is greater than or less than 5. Numbers, by default, have 15decimal places in Excel.

Formulate the ROUND functionas =ROUND(76.677897,2). It will round the number to76.68 (the remainder of the decimals are removed).

It is also possible to insert the ROUND function in front ofa formula to round it off at the same time as completing thecalculation—forexample=ROUND((C7*F9+D3),2).

Leave a Comment