Rounding Up to Nearest .25
I am using FileMaker 10.0.
I need to round up a number to the nearest .25.
1.15 should equal 1.25
.33 shoud equal .50
Any ideas on how to accomplish this?
Round ( YourNumber / .25 ; 0 ) * .25
Or if you want it to round up all the time then try:
Ceiling ( YourNumber / .25 ) * .25
* Edit - Added calc
The 2nd one was perfect - thanks!
This was helpful to me as well. Thanks.
can anyone tell me what value is entered in for "YourNumber"? also what's the equivalent to rounding up to the nearest dollar?
Retrieving data ...