Rounding formula

[Michael J. Malinsky]

Try:

=MROUND(A1,0.05)

A1 refers to the cell of the info. Change as necessary. MROUND may be an
add-in so if it doesn't work at first go to Tools>Add-ins and select the
Analysis Toolpak

HTH

--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain

 

[Kelly L]

Hello-
I am in need of a formula...can anyone help!

I have a list of data which are number such as 11.01 and
11.83. I need a formula that would round 11.21 to 11.20
and round 11.83 to 11.85. I basically need to round to
the nearest tenth. Thanks for any help!

Kelly : )

 

[Frank Kabel]

Hi Kelly
so you want to round to the neares 0.05 ?
Try
=ROUND(your_value*20,0)/20

 

[Stephen]

Hi

Is this what you're looking for =ROUND(A1,1)?

Stephen

 

[JE McGimpsey]

Your words say "nearest tenth", but your numbers say "nearest twentieth":

In General:

=ROUND(A1/N,0)*N

where N is your target tolerance (e.g., 0.05)

Nearest tenth:

=ROUND(A1,1)

Nearest twentieth:

=ROUND(A1/0.05,0)*0.05

also:

=ROUND(A1*2,1)/2