Excel, round off to 5 cents

Project Management, Agile Methodologies, Scrum, Software Development, Software Architecture Styles, Development Platforms, and more...
Post Reply
User avatar
Scotty
Casual User
Casual User
Posts: 19
Joined: Thu Jun 19, 2014 3:48 pm

Excel, round off to 5 cents

Post by Scotty » 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?

User avatar
ivan2019
New User
New User
Posts: 9
Joined: Mon May 28, 2018 12:07 am

Re: Excel, round off to 5 cents

Post by ivan2019 » Mon May 28, 2018 12:13 am

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

User avatar
Scotty
Casual User
Casual User
Posts: 19
Joined: Thu Jun 19, 2014 3:48 pm

Re: Excel, round off to 5 cents

Post by Scotty » 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.

User avatar
ivan2019
New User
New User
Posts: 9
Joined: Mon May 28, 2018 12:07 am

Re: Excel, round off to 5 cents

Post by ivan2019 » Mon May 28, 2018 3:41 pm

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.

User avatar
Scotty
Casual User
Casual User
Posts: 19
Joined: Thu Jun 19, 2014 3:48 pm

Re: Excel, round off to 5 cents

Post by Scotty » Sat Jun 09, 2018 2:51 am

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

User avatar
ivan2019
New User
New User
Posts: 9
Joined: Mon May 28, 2018 12:07 am

Re: Excel, round off to 5 cents

Post by ivan2019 » Tue Jun 12, 2018 5:09 pm

That exercise is left to the user, for practice :-)

User avatar
Scotty
Casual User
Casual User
Posts: 19
Joined: Thu Jun 19, 2014 3:48 pm

Re: Excel, round off to 5 cents

Post by Scotty » 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?

User avatar
ivan2019
New User
New User
Posts: 9
Joined: Mon May 28, 2018 12:07 am

Re: Excel, round off to 5 cents

Post by ivan2019 » Tue Sep 18, 2018 1:49 am

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 ;-)

Post Reply