ExcelBanter - formula to round up to nearest 1,000

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula to round up to nearest 1,000 (https://www.excelbanter.com/excel-discussion-misc-queries/90933-formula-round-up-nearest-1-000-a.html)

Ed Vega

formula to round up to nearest 1,000

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

Tom

formula to round up to nearest 1,000

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

Tom

"Ed Vega" wrote:

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

Toppers

formula to round up to nearest 1,000

=ROUND(A1/1000,0)*1000

"Ed Vega" wrote:

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

Chip Pearson

formula to round up to nearest 1,000

Use a formula like

=ROUNDUP(A1,-3)

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

"Ed Vega" <Ed wrote in message
...
In excell the formula to take the resulted value and round in
up to the
nearest thousand

All times are GMT +1. The time now is 04:21 PM.