Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to count table columns in Excel
  • Managing Conditional Formatting Rules in Excel
  • Example of COUNTIFS with variable table column in Excel
  • How to create a Histogram in Excel
  • How To Perform and Interpret Regression Analysis in Excel

References

  • Get nth match with INDEX / MATCH in Excel
  • How to get first row number in range in Excel
  • Count rows with at least n matching values
  • How to use Excel INDIRECT Function
  • Basic INDEX MATCH approximate in Excel

Data Validations

  • Prevent invalid data entering in specific cells
  • Excel Data validation no punctuation
  • Excel Data validation must contain specific text
  • Excel Data validation allow weekday only
  • Excel Data validation only dates between

Excel Round a number Example

by

If you need to round a number in a normal fashion (i.e. round values of 5 or more up and values less than 5 down) you can use the ROUND function with a specified number of digits.

This tutorials shows how to Round specific number in Excel.

Worked Example:   Calculate years between dates in Excel

Formula

=ROUND(number,digits)

Explanation

In the example, the formula in cell D6 is

=ROUND(B6,C6)

This tells Excel to take the value in B6 (PI) and round it to the number of digits in cell C6 (4) with a result of 3.1416

Worked Example:   How to Use RANK function in Excel

In the table, the ROUND function is used to round the same number (PI) to a decreasing number of digits, starting at 4 and moving down past zero to -1.

Worked Example:   Round a number to n significant digits in Excel

Notice that positive numbers round to the right of the decimal point, while digits specified less than or equal to zero round to the left.

Post navigation

Previous Post:

Number and Text Filters Examples in Excel

Next Post:

Convert date string to date time in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • TRUE function: Description, Usage, Syntax, Examples and Explanation
  • Nested IF function example in Excel
  • Complete List of Excel Logical Functions, References and Examples
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel AND Function

Date Time

  • Get day from date in Excel
  • Convert decimal hours to Excel time
  • Count times in a specific range in Excel
  • NOW function: Description, Usage, Syntax, Examples and Explanation
  • Get last day of month in Excel

Grouping

  • Running count group by n size in Excel
  • Group arbitrary text values in Excel
  • If cell contains one of many things in Excel
  • How to randomly assign data to groups in Excel
  • Group times into 3 hour buckets in Excel

General

  • Select, Insert, Rename, Move, Delete Worksheets in Excel
  • How to make excel worksheets print on one page?
  • Advanced Number Formats in Excel
  • Count cells that contain errors in Excel
  • How to generate random number weighted probability in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning