The ROUND function in Excel returns a number rounded to a given number of digits. This can be used to round a number to the right or left depending on our desired formatting needs.

Syntax:

=ROUND (number,num_digits) 

Arguments:

  • number – Number to round.
  • num_digits – The number of digits the number is to be rounded.

ROUND Function Example

Let’s look at the following examples below. Make sure you download the demonstration file attached to this tutorial.

In the example below, we show how to use this function to round numbers to the right or left.

ROUND Function

ROUND Pricing to $0.99

In this example, we demonstrate how to round pricing to $0.99 by using the formula below. The formula rounds the number to the nearest whole number then subtracts $0.01.

=ROUND(A20,0)-0.01
ROUND Function Price $0.99

Rounding Functions in Excel

ROUND Function – Rounds to a specified number of digits.

ROUNDUP Function – Rounds numbers up a specified decimal place.

ROUNDDOWN Function – Returns a number rounded down to a specified number of places.

FLOOR Function – Rounds a given number down to the nearest specified multiple

MROUND Function – Round a number up or down to a given multiple.

CEILING Function – Rounds a given number up to the nearest specified multiple.

INT Function – Rounds a number down to the nearest integer.

TRUNC Function – Returns a truncated number based on a specified number of digits.

Leave a Reply

VBA Select Method

Selection is a method in Excel VBA that performs an action. You use the Select method to select a single

Read More »

Match Function

Match Function The Match Function searches for a specified value and returns relative position of that value. It’s easier once

Read More »

CUMIPMT Function

How much interested have I paid? The CUMIPMT Function in Excel is a financial function designed to calculate and return

Read More »
Scroll to Top