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?

Re: Excel, round off to 5 cents

Posted: Tue Sep 18, 2018 1:49 am
by ivan2019
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 ;-)