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)

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)

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

"Stupid Scotsman" 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)

Stupid Scotsman Wrote:
"I'm having some problems with the final stages
of Fermat's Last Theorem"

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=514572

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!
--
Kevin Vaughn


"daddylonglegs" wrote:


Stupid Scotsman Wrote:
"I'm having some problems with the final stages
of Fermat's Last Theorem"

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=514572

excellent!
Thankyou gentlemen.


"daddylonglegs" wrote:


Stupid Scotsman Wrote:
"I'm having some problems with the final stages
of Fermat's Last Theorem"

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=514572