software

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 Sjoblomquot;Malquot; gt; wrote in message
...
gt; Hi People,
gt; Is there a way to round up or down in 1/2 units.
gt; e.g. 2.3 up to 2.5, 2.1 down to 2.
gt; Any help appreciated.
gt; Thanks,
gt; Mal
gt;
gt;
On Fri, 06 Jan 2006 20:47:57 GMT, quot;Malquot; gt; wrote:

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

=ROUND(A1*2,0)/2--ron

quot;Malquot; wrote:
gt; Is there a way to round up or down in 1/2 units.
gt; 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 quot;installingquot;
the Analysis ToolPak add-in.

Thanks, works well..
Mal

quot;Malquot; gt; wrote in message
...
gt; Hi People,
gt; Is there a way to round up or down in 1/2 units.
gt; e.g. 2.3 up to 2.5, 2.1 down to 2.
gt; Any help appreciated.
gt; Thanks,
gt; Mal
gt;
gt;
I'm trying to round up or down after executing a formula in a cell.

Here's formula I have in cell
=IF($B$10gt;0, B10/15,quot;quot;)

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

quot;Peo Sjoblomquot; wrote:

gt; With your value in A1
gt;
gt; =ROUND(A1/0.5,0)*0.5
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt;
gt; quot;Malquot; gt; wrote in message
gt; ...
gt; gt; Hi People,
gt; gt; Is there a way to round up or down in 1/2 units.
gt; gt; e.g. 2.3 up to 2.5, 2.1 down to 2.
gt; gt; Any help appreciated.
gt; gt; Thanks,
gt; gt; Mal
gt; gt;
gt; gt;
gt;
gt;
gt;

Try

=IF($B$10gt;0,ROUND(B10/15/0.5,0)*0.5,quot;quot;)

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;DaleWidquot; gt; wrote in message
...
gt; I'm trying to round up or down after executing a formula in a cell.
gt;
gt; Here's formula I have in cell
gt; =IF($B$10gt;0, B10/15,quot;quot;)
gt;
gt; Assuming result is a positive number, I want to round to the nearest .5,
gt; up
gt; or down.
gt;
gt; Thanks for any advice you might have.
gt;
gt; DaleWid
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; With your value in A1
gt;gt;
gt;gt; =ROUND(A1/0.5,0)*0.5
gt;gt; --
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt;
gt;gt; quot;Malquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi People,
gt;gt; gt; Is there a way to round up or down in 1/2 units.
gt;gt; gt; e.g. 2.3 up to 2.5, 2.1 down to 2.
gt;gt; gt; Any help appreciated.
gt;gt; gt; Thanks,
gt;gt; gt; Mal
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;Many thanks, worked perfectly,
Dale Wid

quot;Peo Sjoblomquot; wrote:

gt; Try
gt;
gt; =IF($B$10gt;0,ROUND(B10/15/0.5,0)*0.5,quot;quot;)
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;DaleWidquot; gt; wrote in message
gt; ...
gt; gt; I'm trying to round up or down after executing a formula in a cell.
gt; gt;
gt; gt; Here's formula I have in cell
gt; gt; =IF($B$10gt;0, B10/15,quot;quot;)
gt; gt;
gt; gt; Assuming result is a positive number, I want to round to the nearest .5,
gt; gt; up
gt; gt; or down.
gt; gt;
gt; gt; Thanks for any advice you might have.
gt; gt;
gt; gt; DaleWid
gt; gt;
gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt;
gt; gt;gt; With your value in A1
gt; gt;gt;
gt; gt;gt; =ROUND(A1/0.5,0)*0.5
gt; gt;gt; --
gt; gt;gt;
gt; gt;gt; Regards,
gt; gt;gt;
gt; gt;gt; Peo Sjoblom
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Malquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Hi People,
gt; gt;gt; gt; Is there a way to round up or down in 1/2 units.
gt; gt;gt; gt; e.g. 2.3 up to 2.5, 2.1 down to 2.
gt; gt;gt; gt; Any help appreciated.
gt; gt;gt; gt; Thanks,
gt; gt;gt; gt; Mal
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;