Rounding decimals up or down
 

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

Rounding decimals up or down
 

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

Rounding decimals up or down
 

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

Rounding decimals up or down
 

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