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

Data Analysis

  • How To Remove Duplicates In Excel Column Or Row?
  • How To Perform and Interpret Regression Analysis in Excel
  • How To Create Pareto Chart in Excel
  • Managing Conditional Formatting Rules in Excel
  • How to calculate current stock or inventory in Excel

References

  • Left Lookup in Excel
  • How to create dynamic named range with OFFSET in Excel
  • How to use Excel VLOOKUP Function
  • Count rows that contain specific values in Excel
  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation

Data Validations

  • Data validation must not exist in list
  • Excel Data validation allow uppercase only
  • Excel Data validation allow weekday only
  • Excel Data validation date in specific year
  • Excel Data validation number multiple 100

Tag: FLOOR function

Round time to nearest 15 minutes in Excel

by

This tutorials shows how to Round time to nearest 15 minutes in Excel. To round a time to the nearest 15 minute interval, you can use the MROUND function, which rounds based on a supplied multiple. Formula =MROUND(time,”0:15″) Explanation In the example shown, the formula in C6 is: =MROUND(B6,”0:15″) How this formula works MROUND rounds to …

Continue Reading

Round a number down to nearest multiple in Excel

by

This tutorials shows how to Round a number down to nearest multiple in Excel. If you need to round a number down to the nearest specified multiple (i.e. round a number down to the nearest dollar, down to the nearest $.25, down to the nearest multiple of 5, etc.) you can use the FLOOR function. Formula =FLOOR(number,multiple) …

Continue Reading

Round a number up to nearest multiple in Excel

by

This tutorials shows how to Round a number up to nearest multiple in Excel. If you need to round a number up to the nearest specified multiple (i.e. round a number up to the nearest dollar, up to the nearest $.25, up to the nearest multiple of 5, etc.) you can use the CEILING function. Formula =CEILING(number,multiple) …

Continue Reading

Excel MROUND, CEILING and FLOOR function examples

by

Find Nearest Multiple in Excel This example illustrates three functions to round numbers to a multiple of x in Excel. The MROUND, CEILING and the FLOOR function. Mround 1. For example, round a number to the nearest multiple of 10. 2. For example, round a number to the nearest multiple of 5. Ceiling The same as MROUND but rounds up. Floor The same as …

Continue Reading

FLOOR function: Description, Usage, Syntax, Examples and Explanation

by

What is FLOOR function in Excel? FLOOR function is one of the Math and Trig functions in Microsoft Excel that rounds number down, toward zero, to the nearest multiple of significance. Syntax of FLOOR function FLOOR(number, significance) The FLOOR function syntax has the following arguments: Number: The numeric value you want to round. Significance: The multiple …

Continue Reading

How to generate random times at specific intervals in Excel

by

To generate random times in at specific intervals you can use the RAND function with the FLOOR function. See example below: Formula =FLOOR(RAND(),”0:15″) Explanation In the example shown, the formula in B6 is: =FLOOR(RAND(),”0:15″) which generates a random time at a 15-minute interval. How this formula works The RAND function generates a decimal number between …

Continue Reading

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

  • Extract multiple matches into separate rows in Excel
  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function example in Excel
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • IF with boolean logic in Excel

Date Time

  • Roll back weekday to Friday base on a particular date in Excel
  • Convert text to date in Excel
  • Add days to date in Excel
  • Two ways to sum time over 30 minutes in Excel
  • NETWORKDAYS function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • If cell contains one of many things in Excel
  • Group numbers with VLOOKUP in Excel
  • Group numbers at uneven intervals in Excel
  • Map inputs to arbitrary values in Excel
  • Running count group by n size in Excel

General

  • Hide and Unhide Columns or Rows in Excel
  • Excel Default Templates
  • How to calculate project complete percentage in Excel
  • How to calculate percent of students absent in Excel
  • How to Delete Cells, Row and Rows in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning