+ Reply to Thread
Results 1 to 4 of 4

Rounding numbers up, like 7.50 to 10

  1. #1
    Forum Contributor
    Join Date
    05-16-2007
    Location
    USA
    MS-Off Ver
    MS Office 2016, Excel 2016
    Posts
    160

    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.
    Last edited by Modify_inc; 08-30-2020 at 12:53 PM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,667

    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. #3
    Forum Contributor
    Join Date
    05-16-2007
    Location
    USA
    MS-Off Ver
    MS Office 2016, Excel 2016
    Posts
    160

    Re: Rounding numbers up, like 7.50 to 10

    Quote Originally Posted by Fluff13 View Post
    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. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,667

    Re: Rounding numbers up, like 7.50 to 10

    Glad you sorted it & thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Rounding Numbers
    By NotMuchCode in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-20-2018, 08:13 AM
  2. Replies: 4
    Last Post: 12-17-2015, 12:33 AM
  3. Rounding Numbers after a cancatenation of two numbers with a hyphen
    By daszlosek in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-24-2015, 12:30 PM
  4. [SOLVED] Rounding up numbers
    By Mjh35 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-29-2014, 02:02 PM
  5. Rounding Up/Down numbers
    By Glio in forum Excel General
    Replies: 3
    Last Post: 10-10-2008, 09:49 PM
  6. Rounding numbers down
    By pcharles in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-21-2008, 05:53 AM
  7. Not rounding numbers in VBA
    By serdar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-08-2005, 08:00 PM

Tags for this Thread

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