# Rounding up a decimel number to a whole number

1. ## Rounding up a decimel number to a whole number

Hello,

I would like to round up decimel numbers into whole ones. But, I would like excel to do it this way: if my calculation says that an investment has a return of 13,47% I would like excel to round it up to 15%. Also, if my result is 12,38% I would like excel to round it up to 10%. The thing is, I want it rounded up by 5%. So, if it comes under 12,50% I want 10% and if it comes over 12,50% I would like to round it up to 15% etc...

Is this possible?

2. ## Re: Rounding up a decimel number to a whole number

hi

use this function =CEILING(C19,0.05)

3. ## Re: Rounding up a decimel number to a whole number

Based on your examples, you want

=MROUND(A1, 0.05)

4. ## Re: Rounding up a decimel number to a whole number

Actually, I think you need:

``Please Login or Register  to view this content.``
as this will return (from 7.5 to) 12.49 as "10", and 12.5 (to 17.49) as"15", which seems to be what you're looking for.

Hope this helps.

5. ## Re: Rounding up a decimel number to a whole number

If the cell is formatted as percentage, then 5 correlates to 0.05 so will need 0.05. Hope that helps.

6. ## Re: Rounding up a decimel number to a whole number

Gunner 14, ChemistB,

When I was trying this formula out, I had the cell the formula was in formatted as %, but not A1, which is of course why it didn't work out when I tried Chemist's formula. Apologies for any confusion I may have caused.

7. ## Re: Rounding up a decimel number to a whole number

The MROUND worked like a charm! Because it was percentage, I had to put in 0,05.

Many thanks to everyone!

8. ## Re: Rounding up a decimel number to a whole number

Glad you're sorted out, Gunner. Can you please mark this thread as "Solved" if you're satisfied that it is.

9. ## Re: Rounding up a decimel number to a whole number

I'd be glad to, but I can't seem to find the "solved" button?

And...done!

12. ## Re: Rounding up a decimel number to a whole number

Hello Gunner14,
You can use this
Suppose 12.38 is in B5, & u want 10 in C5
Formula in C5 =FLOOR(B5+2.5,5)

I think it should work
see the file attchd.

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