Rounding Up or down to 1/2 Units

M

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
 
R

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
Click to expand...

=ROUND(A1*2,0)/2


--ron
 
J

joeu2004

Mal said:
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.
Click to expand...

=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.
 
D

DaleWid

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
 
P

Peo Sjoblom

Try

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

--
Regards,

Peo Sjoblom

Portland, Oregon
 
Top