# Rounding numbers up, like 7.50 to 10

1. ## Rounding numbers up, like 7.50 to 10

Is there a way in Excel to round numbers up the way I have them listed below? I'm not sure if this rounding type has a name since it's not likely standard, at least that I know of.

Like so:
7.50 = 10
22.50 = 25
37.50 = 40

Thank you

Update: Actually, I guess that would be considered rounding up to the nearest tens. So, I should try -1 for number of digits. If this works, I will close this thread.

2. ## Re: Rounding numbers up, like 7.50 to 10

To round up to the nearest 5, try
=CEILING.MATH(G3,5)

If you want to roundup to the nearest 10, just change 5 to 10

3. ## Re: Rounding numbers up, like 7.50 to 10

Originally Posted by Fluff13
To round up to the nearest 5, try
=CEILING.MATH(G3,5)

If you want to roundup to the nearest 10, just change 5 to 10
Thanks for the suggestion, I had just figured it out and was about to mark the thread as Solved.

4. ## Re: Rounding numbers up, like 7.50 to 10

Glad you sorted it & thanks for the feedback.

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1