Newbie: How to round down to the lowest 5
 

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

=5*ROUNDDOWN(A1/5,0)

Jerry

Sam wrote:

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

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

"Jerry W. Lewis" wrote:

=5*ROUNDDOWN(A1/5,0)

Jerry

Sam wrote:

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

Thanks Jerry and KS Warrior. Much appreciated!

Cheers,
Sam


"Jerry W. Lewis" wrote in message
...
=5*ROUNDDOWN(A1/5,0)

Jerry

Sam wrote:

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