Rounding to 0.25

Thanks:  0
Likes:  0

# Thread: Rounding to 0.25

1. ## 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. ## Re: Rounding to 0.25

Hi,

Use the Ceiling and Floor functions as :

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

Regards.

3. ## 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
 B1B2B3B4B5B6B7 =

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

## User Tag List

#### Posting Permissions

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