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