• 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: