1. ## 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. ## Re: Roundup to .25

I didn't completely test this: =CEILING(<cell>*100,25)/100

3. ## Re: Roundup to .25

The following should do it:

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

4. ## 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>

5. ## 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.

6. ## Re: Roundup to .25

Lack of consistency of Excel is the hobgoblin of my small mind.

7. ## Re: Roundup to .25

All Office products are consistently inconsistent.

#### Posting Permissions

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