+ Reply to Thread
Results 1 to 12 of 12

Rounding up a decimel number to a whole number

  1. #1
    Registered User
    Join Date
    05-28-2012
    Location
    Croatia
    MS-Off Ver
    Excel 2010
    Posts
    18

    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. #2
    Registered User
    Join Date
    10-15-2012
    Location
    Chennai
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Rounding up a decimel number to a whole number

    hi

    use this function =CEILING(C19,0.05)

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577

    Re: Rounding up a decimel number to a whole number

    Based on your examples, you want

    =MROUND(A1, 0.05)
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    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.
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.

  5. #5
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577

    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. #6
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    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. #7
    Registered User
    Join Date
    05-28-2012
    Location
    Croatia
    MS-Off Ver
    Excel 2010
    Posts
    18

    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. #8
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    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. #9
    Registered User
    Join Date
    05-28-2012
    Location
    Croatia
    MS-Off Ver
    Excel 2010
    Posts
    18

    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?

  10. #10
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577

    Re: Rounding up a decimel number to a whole number

    Above your first post, there's a "thread tools" dropdown menu.

  11. #11
    Registered User
    Join Date
    05-28-2012
    Location
    Croatia
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Rounding up a decimel number to a whole number

    And...done!

  12. #12
    Registered User
    Join Date
    09-21-2012
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2003
    Posts
    93

    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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