Rounding to 1/4 cent

[jberry216]

I wish to round linked volumes to the nearest .0025. Help please.

 

[Steve Hartman]

=MROUND(A1,.0025)

This requires the analysis tool pack

 

[Guest]

Can you make do with the Ceiling function.

i.e. =CEILING(A1,0.0025) ???

 

[Steve Hartman]

Ceiling only rounds UP, not to the nearest.

 

[jberry216]

The MROUND tack returns a #NUM! error

 

[Steve Hartman]

Do you have the analysis ToolPack installed?

 

[jberry216]

Fixed. Note: If the number being evaluated is less than 0, you must put a -.0025

Argument works thusly:

=IF(A1<0,MROUND(A1,-.0025),MROUND(A1,.0025))

Thanks for the help.

 

[Steve Hartman]

Thank YOU! I didn't know that and I didn't even consider negative numbers.