rounding to the nearest thousand
 

I know there has to be a way to do this but how do I round to the nearest
thousand? If cell A1 says 9862, cell B1 should say 10,000. If cell A1 says
9207, cell B1 should say 9000.

rounding to the nearest thousand
 

=Round(number, -3)


"tjb" wrote:

I know there has to be a way to do this but how do I round to the nearest
thousand? If cell A1 says 9862, cell B1 should say 10,000. If cell A1 says
9207, cell B1 should say 9000.

rounding to the nearest thousand
 

=ROUND(A3,-3)

Regards

Trevor


"tjb" wrote in message
...
I know there has to be a way to do this but how do I round to the nearest
thousand? If cell A1 says 9862, cell B1 should say 10,000. If cell A1
says
9207, cell B1 should say 9000.