rounding down to nearest whole 5 or 9

[lrussell5]

i have some prices that need rounding down to the nearest whole 5 or 9
e.g.
81.75 - 79
126 - 125
33.75 - 29
Any help would be much appreciated!

 

[Jon von der Heyden]

Maybe something like this?

=FLOOR(H5,5)-NOT(MOD(FLOOR(H5,5),10))

 

[xenou]

I also came up with:
=(INT(A1/10)*10)+IF(A1-(INT(A1/10)*10)>=5,5,-1)

Or (the same but with FLOOR):
=FLOOR(A1,10)+IF(A1-FLOOR(A1,10)>=5,5,-1)

 

[xenou]

Oops, did not work for 129 or 129.5, so two cases:

=(INT(A1/10)*10)+IF(A1-(INT(A1/10)*10)>=9,9,IF(A1-(INT(A1/10)*10)>=5,5,-1))