Rounding a number to the nearest nickel

[Faron Parlee]

I need to round a munber to the nearest nickel.

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

 

[Bob Phillips]

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)

 

[J.E. McGimpsey]

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

 

[Dave R.]

Try going to google groups and typing in: "excel round nearest cents"

 

[Jason Morin]

One way:

=ROUND(A1/0.05,0)*0.05

HTH
Jason
Atlanta, GA

 

[Peo Sjoblom]

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

 

[Shibashis Bandopadhyay]

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.

 

[Jonathan Rynd]

I need to round a munber to the nearest nickel.

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

=MROUND(A1,0.05)

 

[User]

I need to round a munber to the nearest nickel.

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

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?

 

[Bob Phillips]

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

 

[Frank Kabel]

Hi Bob
if the OP wants to roundDOWN I would use
=ROUNDDOWN(C25/250,0)*250

Frank