HOW TO ROUND UP INTEGER VALUES TO NEAREST TENS EXAMPLE 376 TO 380

  • Thread starter Thread starter v k abbey
  • Start date Start date
V

v k abbey

how to round up integer values or real numbers to nearest tens e.g 214 to
210, 375 t0 380, 576 to 580 etc.
 
I wouldn't call 214 to 210 rounding "up"; however, I think what you want is
this...

=ROUND(A1,-1)

Rick
 
=ROUNDUP(A1/10,0)*10

where A1 is the cell containing the integer you wish to operate on.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding up to the nearest 1000 1
Rounding Time to Nearest 5 Minutes 1
Rounding numbers up or down in same formula 6
Round numbers to get to the nearest 0.09 7
Decimals Constant to 0.50 or Nearest Integer 3
How do I format cells to round up? 6
Round up to nearest 10 5
How do I round a formula result to the next integer? 8

Back
Top