formula to round up to nearest 1,000

Guest · May 27, 2006

In excell the formula to take the resulted value and round in up to the
nearest thousand

Guest · May 27, 2006

Ed,
Assuming your data is in A1...in B1 type:
=CEILING(A1,1000)

Tom

Guest · May 27, 2006

=ROUND(A1/1000,0)*1000

Chip Pearson · May 27, 2006

Use a formula like

=ROUNDUP(A1,-3)

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Round time up to nearest :15	2	Dec 17, 2008
rounding up to nearest specified whole number	1	Dec 31, 2008
Average rounded to nearest 0.50	4	Aug 31, 2009
round up to nearest 50p	1	May 25, 2010
Formula Help	1	Feb 2, 2010
Round Down to the nearest multiple	2	Jan 27, 2010
Round formula	1	Feb 24, 2010
Round-Up question	2	Sep 9, 2009

Ask a Question