Rounding Up or down to 1/2 Units

[Mal]

Hi People,
Is there a way to round up or down in 1/2 units.
e.g. 2.3 up to 2.5, 2.1 down to 2.
Any help appreciated.
Thanks,
Mal

 

[Peo Sjoblom]

With your value in A1

=ROUND(A1/0.5,0)*0.5

 

[Ron Rosenfeld]

Hi People,
Is there a way to round up or down in 1/2 units.
e.g. 2.3 up to 2.5, 2.1 down to 2.
Any help appreciated.
Thanks,
Mal

=ROUND(A1*2,0)/2


--ron

 

[Guest]

Is there a way to round up or down in 1/2 units.
e.g. 2.3 up to 2.5, 2.1 down to 2.

=MROUND(value,0.5)

If MROUND() results in a #NAME? error, see the
MROUND Help text for instructions on "installing"
the Analysis ToolPak add-in.

 

[Mal]

Thanks, works well..
Mal

 

[Guest]

I'm trying to round up or down after executing a formula in a cell.

Here's formula I have in cell
=IF($B$10>0,+B10/15,"")

Assuming result is a positive number, I want to round to the nearest .5, up
or down.

Thanks for any advice you might have.

DaleWid

 

[Peo Sjoblom]

Try

=IF($B$10>0,ROUND(B10/15/0.5,0)*0.5,"")

--
Regards,

Peo Sjoblom

Portland, Oregon

 

[Guest]

Many thanks, worked perfectly,
Dale Wid

Try

=IF($B$10>0,ROUND(B10/15/0.5,0)*0.5,"")

--
Regards,

Peo Sjoblom

Portland, Oregon