Help the stupid Scotsman!!!

S

Stupid Scotsman

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)
 
D

Domenic

Assuming that A1 contains your number, try...

=ROUND(A1/0.5,0)*0.5

Hope this helps!
 
B

bigwheel

You are correct, MROUND will do what you want.
Use it in the form MROUND(A1,0.5) assuming your data is in cell A1
 
D

daddylonglegs

Stupid said:
"I'm having some problems with the final stages
of Fermat's Last Theorem"
Click to expand...

:) hehe - made me laugh :)

By no means a stupid question......I think you probably have a workable
answer but, anyway, if you have any negative numbers MROUND won't work,
so my suggestion would be

=ROUND(A1*2,0)/2
 
K

Kevin Vaughn

I only glanced at the original post and found nothing funny, so when you said
it made you laugh, I went back and re-read it. That was funny!
 
S

Stupid Scotsman

excellent!
Thankyou gentlemen.


daddylonglegs said:
:) hehe - made me laugh :)

By no means a stupid question......I think you probably have a workable
answer but, anyway, if you have any negative numbers MROUND won't work,
so my suggestion would be

=ROUND(A1*2,0)/2
Click to expand...
 
Top