Rounding Up to Nearest Quarter

[grumbachr]

I found this example below on FileMaker forums. Instead of rounding down all the time I would like it to round up or down based on the value. Any suggestions on how to do that?

The following calculation formula will round any number down to the nearest quarter decimal (.00, .25, .50 or .75). For example, the number ...

123.10...would return 123.00. These examples would also follow:

.27 -> .25

.52 -> .50

.86 -> .75

15.98 -> 15.75

25325.98756323 -> 25325.75

157.02 -> 157.00The integer values do not change.

Here's the formula, assuming you have a field called Number:

Int(Number) + Choose(Int(Mod(Number, 1) /.25), 0, .25, .50,.75)

[LaRetta]

"I would like it to round up or down based on the value."

Based upon the value how? We need the specific rules on the point where it should round up or down. :-)

[comment]

Try =

.25 * Round ( 4 * Number  ; 0 )

This doesn't fit your topic title, though.