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

With your value in A1

=ROUND(A1/0.5,0)*0.5
--

Regards,

Peo Sjoblom


"Mal" wrote in message
...
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

On Fri, 06 Jan 2006 20:47:57 GMT, "Mal" wrote:

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

"Mal" wrote:
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.

Thanks, works well..
Mal

"Mal" wrote in message
...
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

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

Here's formula I have in cell
=IF($B$100,+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" wrote:

With your value in A1

=ROUND(A1/0.5,0)*0.5
--

Regards,

Peo Sjoblom


"Mal" wrote in message
...
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

Try

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

--
Regards,

Peo Sjoblom

Portland, Oregon




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

Here's formula I have in cell
=IF($B$100,+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" wrote:

With your value in A1

=ROUND(A1/0.5,0)*0.5
--

Regards,

Peo Sjoblom


"Mal" wrote in message
...
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

Many thanks, worked perfectly,
Dale Wid

"Peo Sjoblom" wrote:

Try

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

--
Regards,

Peo Sjoblom

Portland, Oregon




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

Here's formula I have in cell
=IF($B$100,+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" wrote:

With your value in A1

=ROUND(A1/0.5,0)*0.5
--

Regards,

Peo Sjoblom


"Mal" wrote in message
...
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