Rounding
 

How do I round to the nearest one-half?

3.1 becomes 3
3.4 becomes 3.5
--
jake

Rounding
 

Jake,

Try:

=ROUND(A1*2,0)/2

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Jakobshavn Isbrae" wrote in
message ...
How do I round to the nearest one-half?

3.1 becomes 3
3.4 becomes 3.5
--
jake

Rounding
 

=MROUND(3,1;0,5) (=3)
=MROUND(3,4;0,5) (=3,5)

Activate Tools/Add-Ins/Analisys Toolpak

Regards,
Stefi


€žJakobshavn Isbrae€� ezt Ã*rta:

How do I round to the nearest one-half?

3.1 becomes 3
3.4 becomes 3.5
--
jake

Rounding
 

Stefi & Sandy:

Thank you both very much.
--
jake


"Stefi" wrote:

=MROUND(3,1;0,5) (=3)
=MROUND(3,4;0,5) (=3,5)

Activate Tools/Add-Ins/Analisys Toolpak

Regards,
Stefi


€žJakobshavn Isbrae€� ezt Ã*rta:

How do I round to the nearest one-half?

3.1 becomes 3
3.4 becomes 3.5
--
jake

Rounding
 

You are welcome! Thanks for the feedback!
Stefi


€žJakobshavn Isbrae€� ezt Ã*rta:

Stefi & Sandy:

Thank you both very much.
--
jake


"Stefi" wrote:

=MROUND(3,1;0,5) (=3)
=MROUND(3,4;0,5) (=3,5)

Activate Tools/Add-Ins/Analisys Toolpak

Regards,
Stefi


€žJakobshavn Isbrae€� ezt Ã*rta:

How do I round to the nearest one-half?

3.1 becomes 3
3.4 becomes 3.5
--
jake