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

Try

=ROUND(A1/0.25,0)*0.25

Mike

"Friedbrain" wrote:

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

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" wrote:

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

Many thanks for your help
Martin



"Friedbrain" wrote:

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