I tend to use standard rounding via a user function ROUNDIT(RawVal,DecPl,RoundVal) which uses a similar approach to the example:-
FIX(RawVal * 10^DecPl + (SGN(RawVal) * RoundVal))/ 10 ^ DecPl
where
RawVal is the value to be rounded
DecPl is the number of decimal places required
RoundVal is the rounding factor
This ensures that negative values get rounded DOWN e.g. -1.5 gets rounded to -2.0:cool:
(Useful where a value is contra'd out so that sum of 1.25 and -1.25 returns zero) - if this is not required then change the function to:-
FIX(RawVal * 10^DecPl + RoundVal)/ 10 ^ DecPl
If rounding OFF is required (surplus dec places removed) then RoundVal should be passed as 0.
Trainee Novice:w00t: