Assuming that A1 contains your number, try...

=ROUND(A1/0.5,0)*0.5

Hope this helps!

In article ,
Stupid Scotsman <Stupid wrote:

Hello,

Looking at the other posts ("I'm having some problems with the final stages
of Fermat's Last Theorem") I feel a bit of a doofus for asking but I have
some numbers (about 8000) rounded to 1 decimal place. I'd like to round them
to the nearest 0.5 decimal places

in order to demonstrate my stupidity futher I will provide two examples:

I want 6.4 to become 6.5
I want 6.1 to become 6.0

D'ya catch ma drift?

It seems "mround" might be the puppy I'm after but it doesn't seem to let me
specify cells, only numbers???

Many thanks in advance for replying (I'll feel really silly now if noone does)