hi there all,
I need some help for rounding currency issue..
example:
0.98 round to 0.95
0.95 when round = 0.95
0.91 roun to 0.95.
mean.
i wanna round the end of number 0.98.
if the end of number is 0.01,0.02,0.03&0.04 it would be automatic round to nearest 0.05
*0.01 round = 0.05
*if the mineral water =$0.71 i should get $0.75
and if the end of number is 0.06,0.07,0.08,0.09 it would automatic round to nearest -0.05
*0.06 round = 0.05
*if the mineral water = $0.79 then i should get $0.75
i had googling this for 2months and no answer..
please help me.TQ