# Excel formula to round

Discussion in 'Business Applications' started by soldtheworld, Feb 15, 2007.

Not open for further replies.

Joined:
May 29, 2003
Messages:
136
Hi everyone,
Could someone please tell me what formula to use to round numbers as follow:
For example:
Round \$1.03 to \$1.05
Round \$1.12 to \$1.10
Round \$1.86 to \$1.85

Joined:
Nov 28, 2005
Messages:
62,417
First Name:
Chuck
Try using MROUND. If the original unrounded value is in cell A1 and the rounded value is to go in B1 then set B1 to =MROUND(A1, 0.05)

3. ### draceplace

Joined:
Jun 8, 2001
Messages:
2,583
I think you need the MROUND function in the analysis tool pack.

OOPS i guess I was late

Joined:
Nov 28, 2005
Messages:
62,417
First Name:
Chuck
Ooops, I forgot MROUND was not part of the typical standard Excel installation. This alternate version using the (standard?) ROUND function should work just as well:

=5*(ROUND(A1/5,2))

Joined:
May 29, 2003
Messages:
136
this works perfectly
thank you very much

Joined:
Nov 28, 2005
Messages:
62,417
First Name:
Chuck

As the originator, you can keep our moderators happy by marking this topic solved in the drop down Thread Tools menu above your first post.

As Seen On