Excel, round off to 5 cents
- Scotty
- Casual User
- Posts:19
- Joined:Thu Jun 19, 2014 3:48 pm [phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1275: count(): Parameter must be an array or an object that implements Countable
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 [phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1275: count(): Parameter must be an array or an object that implements Countable
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 [phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1275: count(): Parameter must be an array or an object that implements Countable
Re: Excel, round off to 5 cents
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 [phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1275: count(): Parameter must be an array or an object that implements Countable
Re: Excel, round off to 5 cents
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 [phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1275: count(): Parameter must be an array or an object that implements Countable
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 [phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1275: count(): Parameter must be an array or an object that implements Countable
Re: Excel, round off to 5 cents
That exercise is left to the user, for practice 
