www.triusinc.com

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?

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

Scotty wrote: ↑Sun May 27, 2018 3:49 pm 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.

Scotty wrote: ↑Mon May 28, 2018 12:38 am

Scotty wrote: ↑Sun May 27, 2018 3:49 pm 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.

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

That exercise is left to the user, for practice

ivan2019 wrote: ↑Tue Jun 12, 2018 5:09 pm That exercise is left to the user, for practice

Does that mean you don't know?

Scotty wrote: ↑Sun Jun 24, 2018 5:50 am

ivan2019 wrote: ↑Tue Jun 12, 2018 5:09 pm 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