### Excel ROUND Function

##### Associated Files Download Links

In this Article

*This tutorial demonstrates how to use the Excel ROUND Function in Excel to round a number.*

## ROUND Function Overview

The ROUND Function Rounds a number to a specified number of digits.

To use the ROUND Excel Worksheet Function, select a cell and type:

(Notice how the formula inputs appear)

### ROUND Function Syntax and Inputs:

1 |
=ROUND(number,num_digits) |

**number** – A number.

**num_digits** – The number of decimal places to round. Negative rounds to the left of the decimal.

## How to use the ROUND Function

### Round to Nearest Whole Number

To round to the nearest whole number set the *num_digits* argument to 0.

1 |
=ROUND(A2,0) |

### Round to Two Decimal Places

To round to two decimal places, set the *num_digits* argument to 2. Here we will round a price to the nearest cent:

1 |
=ROUND(B3,2) |

### Round to Nearest 10, 100, or 1000

To round to the other side of the decimal (to 10, 100, or 1000s), use negative numbers:

1 |
=ROUND(A2,-2) |

### Round Percentages

When rounding percentages remember that percentages are decimal values. So to round to the nearest whole percentage use the ROUND Function with *num_digits* = 2.

1 |
=ROUND(A2,2) |

### Round to n Significant Figures

If you need to round a number to n number of significant digits use this formula (click the link to learn more about why this formula works):

1 |
=ROUND(A2,B2-(1+INT(LOG10(ABS(A2))))) |

## Other ROUND Functions / Formulas

Excel / Google Sheets contains many other round functions. Here are quick examples of each:

Read our tutorials to learn more:

Below, we will point out a few functions in particular.

### ROUNDUP and ROUNDDOWN

The ROUNDUP and ROUNDDOWN Functions work exactly the same way as the ROUND Function, except they always round up or down.

1 2 |
=ROUNDUP(A2,-2) =ROUNDDOWN(A2,-2) |

### ROUND to Multiplies

ROUND, ROUNDUP, and ROUNDDOWN round to certain number of decimal places. Instead you can round to multiples by using the MROUND, FLOOR, CEILING Functions.

1 2 3 |
=MROUND(B3,5) =FLOOR(B3,5) =CEILING(B3,5) |

**Round in Google Sheets**

All of the above examples work exactly the same in Google Sheets as in Excel.

## ROUND Examples in VBA

You can also use the ROUND function in VBA. Type:

`application.worksheetfunction.round(number,num_digits)`

For the function arguments (number, etc.), you can either enter them directly into the function, or define variables to use instead.