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: 6
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: 6
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: 6
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?

Post Reply