Rounding to 0.25

[Mel C Roberts]

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

[Jaafar Tribak]

Hi,

Use the Ceiling and Floor functions as :

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

Regards.

[Richie(UK)]

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.65	0.75	*	*
2	0.80	0.75	*	*
3	1.30	1.25	*	*
4	1.40	1.50	*	*
5	1.51	1.50	*	*
6	1.65	1.75	*	*
7	1.73	1.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