We have ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, TRUNC, CEILING, FLOOR, FIXED, EVEN, ODD and a few more. The Microsoft Excel ROUND function returns a number rounded to a specified number of digits. Is it possible to come up with a format which does following. For example, you could create a formula that adds two columns together using the SUM function, and then rounds the result. ROUND Excel function is an inbuilt function in excel which is used to calculate the round number of a given number with the number of digits to be provided as an argument, this formula takes two arguments one which is the number itself and the second argument is the number of digits we want the number to be rounded up to.t. In Excel können Sie die RUNDEN-Funktion nutzen, um Zahlenwerte nach mathematischen Gesetzen zu runden. This method uses the Paste Special option division. Eine Liste mit sämtlichen Formeln übersetzt und einer kurzen Erklärung dazu gibt es auch… Enter the data into your spreadsheet. Cell B3, the first cell that uses one of the ROUND functions to round off the value of pi, rounds this value to 3 because 0 (zero) is used as the num_digits argument of its ROUND function (causing Excel to round the value to the nearest whole number)..