ExcelBanter - How do I round a 4 digits number to it's nearest 10

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

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

- - How do I round a 4 digits number to it's nearest 10 (https://www.excelbanter.com/excel-worksheet-functions/171059-how-do-i-round-4-digits-number-its-nearest-10-a.html)

Fabian Matrix

How do I round a 4 digits number to it's nearest 10

I'm trying to round a 4 digit number to it's nearest 10. Example 1234 to 1230
or 1238 to 1240. How should I do it?

Max

How do I round a 4 digits number to it's nearest 10

In B1: =ROUND(A1,-1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Fabian Matrix" wrote:
I'm trying to round a 4 digit number to it's nearest 10. Example 1234 to 1230
or 1238 to 1240. How should I do it?

Teethless mama

How do I round a 4 digits number to it's nearest 10

=MROUND(A1,10)

"Fabian Matrix" wrote:

I'm trying to round a 4 digit number to it's nearest 10. Example 1234 to 1230
or 1238 to 1240. How should I do it?

All times are GMT +1. The time now is 03:43 AM.