rounding up to the nearest 25

[fancyface]

Hi there. At one time I was given this formula to mimic the ceiling function:

Round(({database.field+2.4999}/5,0)*5

at that time I wanted to round to the nearest $5. Now I need to round to the nearest $25. What should my new numbers be to achieve this?

 

[kskid]

Try this

floor(({table.field}+12.4999)/25)*25

 

[lbass]

I think you just need to use:

round({table.number}/25)*25

...as long as you really mean you want the nearest value. If you want to round up, there is a function in XI:

roundup({table.number}/25)*25

-LB