ExcelBanter - Rounding Question

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Rounding Question (https://www.excelbanter.com/excel-worksheet-functions/216643-rounding-question.html)

Art

Rounding Question

Is it possible to create a rounding formula for the following?

270,400 = 270
270,600 = 271

Gary''s Student

Rounding Question

=ROUND(A1/1000,0)

--
Gary''s Student - gsnu200827

"Art" wrote:

Is it possible to create a rounding formula for the following?

270,400 = 270
270,600 = 271

David Biddulph[_2_]

Rounding Question

=ROUND(A2/1000,0) ?
--
David Biddulph

"Art" wrote in message
...
Is it possible to create a rounding formula for the following?

270,400 = 270
270,600 = 271

All times are GMT +1. The time now is 02:59 PM.