# XL FORMULA FOCUS: ROUND, ROUNDUP, ROUNDDOWN, MROUND (an introduction to Excel rounding functions)

Here is a quick introduction to four straight-forward rounding functions in Excel. We’ll look at each formula in the picture above and how they help you to round numbers.

ROUND(number, num_digits)

This is probably what you think of instinctively when you hear the word “rounding”, and so this might be the formula you use most often. In the example above we’re rounding to two decimal places, so if the third decimal place is 5 or above we round the second decimal place up, and if the third decimal place is below 5 we round the second decimal place down. If num_digits is 0 then it rounds to the nearest integer, and if num_digits is negative the number is rounded to the left of the decimal point.

ROUNDUP(number, num_digits)

You’ll start to see a theme emerging here – all of these rounding functions follow the same syntax (number, num-digits). So if you understand ROUND then ROUNDUP should be fairly intuitive for you. But just to spell it out, in the example above we’re rounding to two decimal places, so if the third decimal place is above 0 it rounds the second decimal place up, otherwise it stays the same.

ROUNDDOWN(number, num_digits)

Again the same format, only this time we’re rounding down. In the example above we’re rounding to two decimal places, so regardless of what the third decimal place is, we’re chopping it off and the second decimal place stays as it is.

MROUND(number, num_digits)

MROUND, or Multiple Round, rounds your number to the nearest multiple of your choice (guess what – same syntax!). So above we decide to round to the nearest 5, and it uses “standard” rounding and returns the figure up or down to the nearest multiple of 5.

That was your whistle-stop tour of Excel’s most straightforward rounding functions. Thanks for listening!

# Excel Keyboard Shortcuts – Control with Symbols

Another selection of keyboard shortcuts. Press Control and the following symbols:

` – Toggles between displaying cell values and formulas in the current worksheet.

~ – Cell format is General.

! – Cell format is Number with two decimal places, commas, and minus symbol for negative values.

@ – Cell format is Time hour and minute, and AM or PM.

# – Cell format is Date (dd-mmm-yy).

\$ – Cell format is Currency (with 2 decimal places and negatives in brackets).

% – Cell format is Percentage (with no decimal places).

^ – Cell format is Exponential with two decimal places.

& – Adds outline border on selected cells.

* – Selects the range of cells around the active cell.

( – Unhides all hidden rows in the selection.

) – Unhides all hidden columns in the selection.

– – Delete the selected cells.

_ – Removes outline border on selected cells.

+ – Insert cells.

; – Enters the current date.

: – Enters the current time.

‘ – Copies a formula from the cell above.

” – Copies the value from the cell above.