Page 1 of 1

Excel, round off to 5 cents

Posted: Sun May 27, 2018 3:49 pm
by 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?

Re: Excel, round off to 5 cents

Posted: Mon May 28, 2018 12:13 am
by ivan2019
Why can't you just use the mround() function? It does exactly that!

Re: Excel, round off to 5 cents

Posted: Mon May 28, 2018 12:38 am
by Scotty
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.

Re: Excel, round off to 5 cents

Posted: Mon May 28, 2018 3:41 pm
by ivan2019
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.

Re: Excel, round off to 5 cents

Posted: Sat Jun 09, 2018 2:51 am
by Scotty
Thanks! Is there a way to get the same round-off without using a built-in function? Like base principles?

Re: Excel, round off to 5 cents

Posted: Tue Jun 12, 2018 5:09 pm
by ivan2019
That exercise is left to the user, for practice :-)

Re: Excel, round off to 5 cents

Posted: Sun Jun 24, 2018 5:50 am
by Scotty
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?