Need to round coded function to nearest .05 or .01

[greegan]

The resulting amount can be rounded to the nearest multiple of $0.05 or $0.01.

In vba how would you do this? I don't have the formula I'm going to use for this (right now) but is currency (hope that helps).

-- g

 

[baodinh]

Try the function =MRound(A2,0.05) which will round the value in cell A2 in multiples of $0.05.