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

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.
 
R

Rick Rothstein \(MVP - VB\)

I wouldn't call 214 to 210 rounding "up"; however, I think what you want is
this...

=ROUND(A1,-1)

Rick
 
B

Bernard Liengme

Dear Abbey:

=ROUND(A1,-1) for tens
=ROUND(A1,-2) for hundreds,
etc
best wishes
 
A

Andereida

=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
Round numbers to get to the nearest 0.09 7
Round up to nearest 10 5
Decimals Constant to 0.50 or Nearest Integer 3
How do I format cells to round up? 6
How do I round a formula result to the next integer? 8
How do I get a calculated amount to round to the nearest nickel? 3
fit multiple values into specific value (combinations?) 4

Top