Thread: HOW TO ROUND UP INTEGER VALUES TO NEAREST TENS EXAMPLE 376 TO 380
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andereida Andereida is offline
external usenet poster
  
Posts: 1
Default HOW TO ROUND UP INTEGER VALUES TO NEAREST TENS EXAMPLE 376 TO 380
=ROUNDUP(A1/10,0)*10

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

HTH


"v k abbey" wrote:

how to round up integer values or real numbers to nearest tens e.g 214 to
210, 375 t0 380, 576 to 580 etc.
Reply With QuoteReply With Quote