formula to round up to nearest 1,000

[Ed Vega]

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

 

[Tom]

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

Tom

 

[Toppers]

=ROUND(A1/1000,0)*1000

 

[Chip Pearson]

Use a formula like

=ROUNDUP(A1,-3)


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