## Excel, round off to 5 cents

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

### Excel, round off to 5 cents

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?
ivan2019
New User
Posts: 9
Joined: Mon May 28, 2018 12:07 am

### Re: Excel, round off to 5 cents

Why can't you just use the mround() function? It does exactly that!
Scotty
Casual User
Posts: 19
Joined: Thu Jun 19, 2014 3:48 pm

### Re: Excel, round off to 5 cents

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.
ivan2019
New User
Posts: 9
Joined: Mon May 28, 2018 12:07 am

### Re: Excel, round off to 5 cents

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.
Scotty
Casual User
Posts: 19
Joined: Thu Jun 19, 2014 3:48 pm

### Re: Excel, round off to 5 cents

Thanks! Is there a way to get the same round-off without using a built-in function? Like base principles?
ivan2019
New User
Posts: 9
Joined: Mon May 28, 2018 12:07 am

### Re: Excel, round off to 5 cents

That exercise is left to the user, for practice
Scotty
Casual User
Posts: 19
Joined: Thu Jun 19, 2014 3:48 pm

### Re: Excel, round off to 5 cents

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?
ivan2019
New User
Posts: 9
Joined: Mon May 28, 2018 12:07 am

### Re: Excel, round off to 5 cents

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