Rounding decimals up or down

[Friedbrain]

I've read loads of previous posts but can't find exactly what I'm after.

I need to be able round a decimal number up OR down to the nearest 0.25, eg

1.05 needs to be 1.0
1.12 needs to be 1.0
1.19 neeeds to be 1.25
1.39 needs to be 1.5 etc.....

Many Thanks

 

[Mike H]

Try

=ROUND(A1/0.25,0)*0.25

Mike

 

[rajesh]

Hi

Function "MROUND" solves your problem

To get this function pls install analysis toolpak (Tools > Add Ins)

Syntax MROUND(number,multiple)

enter 0.25 as muliple.

 

[Friedbrain]

Many thanks for your help
Martin