software

Hello,

Looking at the other posts (quot;I'm having some problems with the final stages
of Fermat's Last Theoremquot;) 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 quot;mroundquot; 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 gt;,
Stupid Scotsman lt;Stupid gt; wrote:

gt; Hello,
gt;
gt; Looking at the other posts (quot;I'm having some problems with the final stages
gt; of Fermat's Last Theoremquot;) I feel a bit of a doofus for asking but I have
gt; some numbers (about 8000) rounded to 1 decimal place. I'd like to round them
gt; to the nearest 0.5 decimal places
gt;
gt; in order to demonstrate my stupidity futher I will provide two examples:
gt;
gt; I want 6.4 to become 6.5
gt; I want 6.1 to become 6.0
gt;
gt; D'ya catch ma drift?
gt;
gt; It seems quot;mroundquot; might be the puppy I'm after but it doesn't seem to let me
gt; specify cells, only numbers???
gt;
gt; Many thanks in advance for replying (I'll feel really silly now if noone does)
gt;
gt;

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

quot;Stupid Scotsmanquot; wrote:

gt; Hello,
gt;
gt; Looking at the other posts (quot;I'm having some problems with the final stages
gt; of Fermat's Last Theoremquot;) I feel a bit of a doofus for asking but I have
gt; some numbers (about 8000) rounded to 1 decimal place. I'd like to round them
gt; to the nearest 0.5 decimal places
gt;
gt; in order to demonstrate my stupidity futher I will provide two examples:
gt;
gt; I want 6.4 to become 6.5
gt; I want 6.1 to become 6.0
gt;
gt; D'ya catch ma drift?
gt;
gt; It seems quot;mroundquot; might be the puppy I'm after but it doesn't seem to let me
gt; specify cells, only numbers???
gt;
gt; Many thanks in advance for replying (I'll feel really silly now if noone does)
gt;
gt;


Stupid Scotsman Wrote:
gt; quot;I'm having some problems with the final stages
gt; of Fermat's Last Theoremquot;
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: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=514572I 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 Vaughnquot;daddylonglegsquot; wrote:

gt;
gt; Stupid Scotsman Wrote:
gt; gt; quot;I'm having some problems with the final stages
gt; gt; of Fermat's Last Theoremquot;
gt;
gt; hehe - made me laugh
gt;
gt; By no means a stupid question......I think you probably have a workable
gt; answer but, anyway, if you have any negative numbers MROUND won't work,
gt; so my suggestion would be
gt;
gt; =ROUND(A1*2,0)/2
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=514572
gt;
gt;

excellent!
Thankyou gentlemen.quot;daddylonglegsquot; wrote:

gt;
gt; Stupid Scotsman Wrote:
gt; gt; quot;I'm having some problems with the final stages
gt; gt; of Fermat's Last Theoremquot;
gt;
gt; hehe - made me laugh
gt;
gt; By no means a stupid question......I think you probably have a workable
gt; answer but, anyway, if you have any negative numbers MROUND won't work,
gt; so my suggestion would be
gt;
gt; =ROUND(A1*2,0)/2
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=514572
gt;
gt;