Rounding Numbers
 

How do i round numbers to the nearest thousand?

=MROUND(A1,1000)

Tim C

"Simon" wrote in message
...
How do i round numbers to the nearest thousand?

Or if ATP is not installed

=ROUND(A1,-3)



--

Regards,

Peo Sjoblom

"Tim C" wrote in message
...
=MROUND(A1,1000)

Tim C

"Simon" wrote in message
...
How do i round numbers to the nearest thousand?

I got a "NAME ERROR" when i did that, how do i solve this problem

"Tim C" wrote:

=MROUND(A1,1000)

Tim C

"Simon" wrote in message
...
How do i round numbers to the nearest thousand?

Because you do not have Analysis Toolpac installed

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Simon" wrote in message
...
I got a "NAME ERROR" when i did that, how do i solve this problem

"Tim C" wrote:

=MROUND(A1,1000)

Tim C

"Simon" wrote in message
...
How do i round numbers to the nearest thousand?

Go to Help for this function and read it.

On Thu, 3 Feb 2005 14:45:02 -0800, "Simon"
wrote:

I got a "NAME ERROR" when i did that, how do i solve this problem

"Tim C" wrote:

=MROUND(A1,1000)

Tim C

"Simon" wrote in message
...
How do i round numbers to the nearest thousand?