Fred,
To round to the left of the decimal point use a negative argument to the round() function.
? round( 123456.78, -1 )
? round( 123456.78, -2 )
To get 5 cent rounding you'll have to multiply and divide by 20 like the others have shown.
>Is there an easy way of using the native Rounding function(s) to round like
>
>i) To the Nearest 10 whereby 18571.47 becomes 18580.00 UP and 18570 Down ?
>ii) To the Nearest 5 Cent Where 18571.47 becomes 18571.50 Up and 18571.45 Down
>
>Currently I am using a complex String manipulation function to achieve this.
