+ Reply to Thread
Results 1 to 5 of 5

Round Cell to Nearest 0.25 up-to 1.0 then to nearest 0.5

  1. #1
    Registered User
    Join Date
    05-30-2012
    Location
    UK
    MS-Off Ver
    365
    Posts
    7

    Round Cell to Nearest 0.25 up-to 1.0 then to nearest 0.5

    Hello all ...

    Round Cell to Nearest 0.25 up-to 1.0 then to nearest 0.5

    Is it possible to get the the following results:

    0.1 - 0.25
    0.15 - 0.25
    0.2 - 0.25
    0.22 - 0.25
    0.4 - 0.5
    0.6 - 0.5
    0.7 - 0.75
    0.9 - 1.0

    1.2 - 1.00
    1.4 - 1.5

  2. #2
    Forum Contributor
    Join Date
    06-23-2010
    Location
    Iowa, United States
    MS-Off Ver
    Excel 2007
    Posts
    145

    Re: Round Cell to Nearest 0.25 up-to 1.0 then to nearest 0.5

    Try:

    =IF(A20>1,ROUND(A20*2,0)/2,ROUND(A20*4,0)/4)

    Let me know if this works!

    Steve

    ***If someone gave you good help, be sure to click the star at the bottom of their post!***

  3. #3
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Round Cell to Nearest 0.25 up-to 1.0 then to nearest 0.5

    I don't see why .1 wouldn't be 0 (if .6 is to be .5) but this yields all the same results as your sample

    =MAX(MROUND(A1,IF(A1>1,0.5,0.25)),0.25)

  4. #4
    Registered User
    Join Date
    05-30-2012
    Location
    UK
    MS-Off Ver
    365
    Posts
    7

    Re: Round Cell to Nearest 0.25 up-to 1.0 then to nearest 0.5

    Quote Originally Posted by cutter View Post
    i don't see why .1 wouldn't be 0 (if .6 is to be .5) but this yields all the same results as your sample

    =max(mround(a1,if(a1>1,0.5,0.25)),0.25)
    perfect thanks !

  5. #5
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Round Cell to Nearest 0.25 up-to 1.0 then to nearest 0.5

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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