Round or Ceiling math expression

[CMsDeveloper]

I want to round or ceiling to the nearest .25 with this app formula.

IF( iSBLANK([amount]) ,CEILING([calc hours]) * LOOKUP([Equipment], “Services”, “Service”, “Rate”) , LOOKUP([Job Name], “Accounts”, “Account”, “Amount”))

Some rates are $250/hour so I need to round by decimal places rather than by integers.

[Steve]

There’s no built-in function to do what you want, so you’ll have to calculate it.

[Aleksi · Accepted solution]

@CMsDeveloper You can do that like CEILING([YourDecimalValue]*4)*0.25

[Jonathon]

Thats a lot cleaner of an expression that I had envisioned; cheers Aleksi.

[CMsDeveloper]

Perfect. Thanks!

[Aleksi]

@Jonathon Simple is more beatiful

[Aleksi]

You’re welcome