+ Reply to Thread
Results 1 to 3 of 3

MROUND formula

  1. #1
    Registered User
    Join Date
    10-20-2011
    Location
    Cape Town, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    6

    MROUND formula

    Hi There,
    I am using the MROUND formula and it works well, but I need to force the result to the next multiple, i.e. always roundup instead of to the closest multiple. Any ideas? I have tired imbedded and sharing formulae - just a frustration at the moment...

    Arthur, your suggestion on the MOD formula ROCKS - thanks a mil!

    -Sascha-

  2. #2
    Forum Expert Colin Legg's Avatar
    Join Date
    03-30-2008
    Location
    UK
    MS-Off Ver
    2003, 2007, 2010, 2013
    Posts
    1,252

    Re: MROUND formula

    I think CEILING (or, since you are using XL 2010, CEILING.PRECISE) will do what you want.

    =CEILING.PRECISE(A1,3)
    Hope that helps,

    Colin

    RAD Excel Blog

  3. #3
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: MROUND formula

    Try changing:
    =MROUND(Number, Multiple)
    to
    =MROUND(Number + Multiple/2, Multiple)

    Pauley

+ 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