Rounding down to nearest quarter 1

[JoannDavies]

Another rounding problem! I've searched the posts and can't quite make them work for what I need!

I need to be able to round a number down (always down!) to the nearest quarter (.00 or .25 or .50 or .75).

Can anyone help me?

Thank you!

Joann

 

[PHV]

Int(4*[number])/4

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[JoannDavies]

Sorry I didn't reply before, but I got sidetracked onto another job. But I'm back again now and this was just exactly what I needed. Thank you so much! Joann