How to roundup a number to the closest ten?

by

You could also use CEILING which rounds up to an integer or desired multiple of significance

ie
=CEILING(A1,10)
rounds up to a multiple of 10

12340.0001 will become 12350

More Related Contents:

  1. Want to concatenate multiple row data in in cell along with its values if present. Emp Id should not come if no data available infromt of it
  2. Excel Number Separation [closed]
  3. Excel formula checklist in employees
  4. Sequence of numbers based on start and end value of 2 cells [closed]
  5. Error in finding last used cell in Excel with VBA
  6. Excel VBA – How to add dynamic array formula
  7. Filling any empty cells with the value above
  8. Find last used cell in Excel VBA
  9. Count unique values in Excel
  10. Concatenate column headers if value in rows below is non-blank
  11. How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004
  12. Countif With Multiple OR Criteria
  13. How to extract text within a string of text
  14. How to get MS Excel to list files in a folder with their metadata (in particular, the tags created for the files)?
  15. Excel – opening file stuck on 100%, until VBA code finishes
  16. How to add a reference programmatically using VBA
  17. automatically execute an Excel macro on a cell change
  18. VLOOKUP with multiple criteria returning values in one cell
  19. VBA check if file exists
  20. Copy/Paste/Calculate Visible Cells from One Column of a Filtered Table
  21. Trying to use variables as values vba to sql
  22. How to call a macro from a button and pass arguments
  23. VBA (Excel) Dictionary on Mac?
  24. Refresh Excel VBA Function Results
  25. Code for looping through all excel files in a specified folder, and pulling data from specific cells
  26. Update excel sheet based on outlook mail [closed]
  27. Using the value in a cell as a cell reference in a formula?
  28. How to count cells in a range with a value less than another cell in excel?
  29. Excel: How to gather unique values in one column that are associated with duplicates in another column?
  30. Check whether a cell contains a substring

Leave a Comment