Excel, round off to 5 cents

[Scotty]

Hey, does anyone know how to set up a formula to always round off to the closest 5 cents, on a financial operation, in excel?

[ivan2019]

Why can't you just use the mround() function? It does exactly that!

[Scotty]

Hey, does anyone know how to set up a formula to always round off to the closest 5 cents, on a financial operation, in excel?

Well, truth is I was looking for a formula in excel because I wanted to then code it in my program, that's where I have the need for it.

[ivan2019]

Hey, does anyone know how to set up a formula to always round off to the closest 5 cents, on a financial operation, in excel?

Well, truth is I was looking for a formula in excel because I wanted to then code it in my program, that's where I have the need for it.

Oh, I didn't realize that. Try this formula, it should provide the same results:

=ROUND(A2/0.05,0)*0.05

The 0.05 part could be a variable for rounding to other values.

[Scotty]

Thanks! Is there a way to get the same round-off without using a built-in function? Like base principles?

[ivan2019]

That exercise is left to the user, for practice

[Scotty]

That exercise is left to the user, for practice

Does that mean you don't know?

[ivan2019]

That exercise is left to the user, for practice

Does that mean you don't know?

Take it any way you want. Sometimes you've got to do some work, to get the results you want, instead for just asking for the answer