Round off based on third decimal place

[RvG14344]

Hi dears,

I would like to know the easiest way to do this in excel and I will really appreciate your help.


If the third decimal place is 1 or 2 or 6 or 7 round down to nearest 5.
If the third decimal place is 3 or 4 or 8 or 9 round up to nearest 5.

Examples:

Tax = 50.032 then round to Tax = 50.030
Tax = 50.037 then round to Tax = 50.035
Tax = 50.034 then round to Tax = 50.035
Tax = 50.038 then round to Tax = 50.040

 

[sunrise06]

=mround(a2,0.005)

 

[RvG14344]

OMG, thank you so much

God bless you.