Newbie: How to round down to the lowest 5

[Sam]

I am trying to write a formula that will allow me to round down the
lowest digit, say 5. For example if the value in A1= 1297.19 then the value
in A2 should display 1295.00 also if the value in A1=632.67 then I would
want to round down to 630.00.

Can anyone help?

Thanks

 

[Jerry W. Lewis]

=5*ROUNDDOWN(A1/5,0)

Jerry

 

[K.S.Warrier]

=int(A1/5)*5
K.S.Warrier

=5*ROUNDDOWN(A1/5,0)

Jerry

 

[Sam]

Thanks Jerry and KS Warrior. Much appreciated!

Cheers,
Sam