Rounding a number to the nearest nickel

  • Thread starter Thread starter Faron Parlee
  • Start date Start date
F

Faron Parlee

I need to round a munber to the nearest nickel.

eg. $157.532 = $157.50
$148.649 = $148.65
 
Faron,

You could just format to 2 dec places if it is only how it looks that
matters. If it is also necessary to have the value rounded to 2 dec places
as well, use

=ROUND(A1,2)

and format to 2 dec places.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
The general form is

=ROUND(A1/N,0)*N

so to round to the nearest nickel:

=ROUND(A1/0.05,0)*0.05

or, equivalently,

=ROUND(A1*20,0)/20
 
I think you got the first one wrong unless you meant nearest dime?

=ROUND(A1/0.05,0)*0.05

would return 157.55 rounded to the nearest nickel
nearest dime would be

=ROUND(A1/0.1,0)*0.1
 
Just use the mround function like this
=mround("cellreference",0.050)
if this function is not available you have to
load it going to the tools menu & selecting add-ins.
Type mround or rounding of digits in help.
It's easy.
 
I need to round a munber to the nearest nickel.

eg. $157.532 = $157.50
$148.649 = $148.65
Click to expand...


I am in a similar situation, but need to round down to the nearest
multiple of 250.

I don't think the mround function can be combined like the round
function can? (rounddown)

Any help?
 
=ROUND(C25/250,0)*250


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top