rounding currency

I am trying to figure out how to round a currency number to that payable of cash.
eg. $4.76 to automatically change to $4.75
Would anybody know how to achieve this if possible?

Hi

Try
=MROUND(A1,0.05)

where your value is in A1.

rylo

thanks, that works. the it guy just also suggested the floor calculation.