Rounding to 0.25

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Rounding to 0.25

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    England
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Rounding to 0.25

     
    Please help.

    I need to round information in a spreadsheet to the nearest 0.25
    So data either reads, for example, 1.25, 1.50, 1.75 or 2.00 and nothing in between i.e. if the value is 1.3 it would round down to 1.25 and if it was 1.4 it would round up to 1.5

    I am sure this is not too tricky but is driving me crazy!!

    Please help

  2. #2
    Board Regular Jaafar Tribak's Avatar
    Join Date
    Dec 2002
    Location
    Larache--Morocco
    Posts
    6,238
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Rounding to 0.25

    Hi,

    Use the Ceiling and Floor functions as :

    =CEILING(A1,0.25)
    =Floor(A1,0.25)

    Regards.
    Office/Excel 2010 64Bits -- Win10 64Bits

    Common sense is not so common.


    http://photo-larache.blogspot.com/

  3. #3
    MrExcel MVP Richie(UK)'s Avatar
    Join Date
    May 2002
    Location
    UK
    Posts
    3,329
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Rounding to 0.25

      
    Hi Mel,

    How about MRound from the Analysis toolpack?


    ******** ******************** ************************************************************************>
    Microsoft Excel - Book1___Running: xl97 : OS = Windows ME
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    A
    B
    C
    D
    1
    0.650.75
    2
    0.800.75
    3
    1.301.25
    4
    1.401.50
    5
    1.511.50
    6
    1.651.75
    7
    1.731.75
    Sheet1

    [HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.



    HTH
    Richie

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com