+ Reply to Thread
Results 1 to 4 of 4

Rounding Formula that spits out multiples of 5

  1. 02-11-2019, 03:10 PM #1
    500bloc
    500bloc is offline
    Registered User
    Join Date
    06-15-2010
    Location
    ATL
    MS-Off Ver
    Excel 2000
    Posts
    34

    Rounding Formula that spits out multiples of 5

    I'm trying to get a formula that rounds to multiples of 5. For example, if an answer is 63, I want it to be 65. If it's 72, I'd like it to be 70. I'm currently stumped for an answer
    Reply With QuoteRegister To Reply
  2. 02-11-2019, 03:12 PM #2
    MrShorty
    MrShorty is offline
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,814

    Re: Rounding Formula that spits out multiples of 5

    Assuming you want to round 2.5 and 7.5 (halfway marks) always up, you can use the MROUND() function for this: =MROUND(value,5) https://support.office.com/en-us/art...b-d2d5b3baf427
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.
    Reply With QuoteRegister To Reply
  3. 02-11-2019, 04:36 PM #3
    Ghozi Alkatiri
    Ghozi Alkatiri is offline
    Valued Forum Contributor
    Join Date
    10-29-2012
    Location
    Mojokerto,Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    554

    Re: Rounding Formula that spits out multiples of 5

    use ceiling
    =CEILING(62,5)
    Reply With QuoteRegister To Reply
  4. 02-12-2019, 12:28 AM #4
    500bloc
    500bloc is offline
    Registered User
    Join Date
    06-15-2010
    Location
    ATL
    MS-Off Ver
    Excel 2000
    Posts
    34

    Re: Rounding Formula that spits out multiples of 5

    Thank you both for the help, it worked
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Multiples Index/Match/Multiples Columns But to be concatenate in respective Rows
    By AndyJr in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 12-09-2018, 11:21 PM
  2. Sorting Data based on a report my software spits out
    By dellam in forum Excel General
    Replies: 0
    Last Post: 06-27-2015, 09:08 PM
  3. [SOLVED] Rounding by Varying Multiples
    By ldoherty in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-28-2014, 02:13 AM
  4. [SOLVED] Formula for dividing and rounding a number with multiples of 500
    By mojitomaster in forum Excel General
    Replies: 5
    Last Post: 05-14-2012, 07:11 AM
  5. Rounding to Multiples WITH IF's
    By SCCCJ in forum Excel General
    Replies: 6
    Last Post: 04-21-2011, 01:21 PM
  6. Rounding from multiples
    By Audiguy82 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 12-03-2007, 04:31 PM
  7. [SOLVED] rounding to multiples in excel ?
    By HR gal in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2006, 02:45 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1