rounding to the nearest thousand

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding figures to nearest thousand 3
Rounding 2
Rounding 5
Rounding to the nearest quarter 2
Round amount to nearest $10 after other formula calc. in same cell 4
WHATS AN EASY FUNCTION TO USE TO ROUND TO THE NEAREST THOUSAND? 4
Rounding Up question 2
Alternate Rounding Up & Down of .50 in a column 5

Top