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! Go to Solution.
@CMsDeveloper You can do that like CEILING([YourDecimalValue]*4)*0.25
User | Count |
---|---|
17 | |
12 | |
5 | |
5 | |
5 |