Help the 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)

Assuming that A1 contains your number, try...

=ROUND(A1/0.5,0)*0.5

Hope this helps!

In article <075CD72C-843A-4488-8D63-CF993195126B@microsoft.com>,
Stupid Scotsman <Stupid Scotsman@discussions.microsoft.com> 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)
>
>

Originally Posted by Stupid Scotsman

"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

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