Round or Ceiling math expression

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.

Solved Solved
0 6 1,061
1 ACCEPTED SOLUTION

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

View solution in original post

6 REPLIES 6
Top Labels in this Space