As opposed to what norm? The built in Round function will round .5 to the nearest even
number whether that be up or down. The most frequent rounding in the US is to always round
up .5, but everything else goes up or down to the nearest number. If you always want to go
down, even if the value is .9, then all you need to do is truncate the decimal portion of
the number, check the help file for the FIX and INT functions. If you aren't wanting to
"round" to the ones position, you will need to multiply or divide to put the position you
want to "round" to in the ones position, run one of the 2 functions mentioned above, then
do the reverse of the multiply or divide that you did above to put the position you're
"rounding" to back where it belongs.
Example:
"Round" to ones position
RoundedNumber = Int(Number)
"Round" to tens position
RoundedNumber = Int(Number / 10) * 10
"Round" to tenths position
RoundedNumber = Int(Number * 10) / 10
The difference in INT and FIX is in how they handle negative numbers.
If this isn't what you want, will you be more specific and I'll adjust the formula.
