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?

Book1
	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

HTH