Results 1 to 7 of 7

Thread: Roundup to .25

  1. #1
    Lounger
    Join Date
    Mar 2001
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Roundup to .25

    Is there a simple way to round a number up to the nearest .25 (ex. 1.2 becomes 1.25, 4.6 becomes 4.75). I know I can have a number displayed rounded to the nearest .25, but I need to use the number in other calculations after it is rounded. (ex. 2.1 and 3.1 should display as 2.25 and 3.25, and when added together should equal 5.5 (not 5.25 as it would if I added 2.1 and 3.1 and then rounded up))
    I assume I could do this with a series of IF statements, but I'm looking for an easier way.

    TIA,
    Gary

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Roundup to .25

    I didn't completely test this: =CEILING(<cell>*100,25)/100
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Roundup to .25

    The following should do it:

    <pre>=CEILING(A1,0.25)
    </pre>

    Legare Coleman

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Roundup to .25

    Leaving me wondering where I got the idea that significance can only be specified in whole numbers ... <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Roundup to .25

    You were probably thinking of the Round function where you specify the number of digits and have to play those games to round to something like the nearest multiple of 5.
    Legare Coleman

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Roundup to .25

    Lack of consistency of Excel is the hobgoblin of my small mind.
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Roundup to .25

    All Office products are consistently inconsistent.
    Legare Coleman

Posting Permissions

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