Round and MRound

I discovered recently that, not only is there an MRound (read more here), there is also a ROUND function in Excel so that the cells display whole numbers! Foolishly, I had been using MRound and entering "0.99999999999999" to force my rounding to display whole numbers, before realising that OF COURSE there would be a whole number function.

In doing a search for something else, I stumbled across a simple Round formula (Suprov, 2024). And it is simple. Instead of using MRound, we just use "Round".

So where I had previously used MRound:

• where I had wanted to fudge a whole number, using MRound, I would have previously entered the formula
  =MROUND(A2,0.99999999999999)

But more simply, if we want whole numbers in future, we just use Round:

• so, for example, where we might want a figure rounded to a whole mark, using Round, we would enter the formula
  =ROUND(A2,0)

So easy when we know how. Thank you, Suprov (2024)!

Sam

Reference:

Suprov, R. R. (2024, June 23). How to Round to Nearest Whole Number in Excel (9 Methods). ExcelDemy. https://www.exceldemy.com/learn-excel/number-format/rounding/nearest-whole-number/