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

Data Analysis

  • What-If Analysis: Scenarios and Goal Seek in Excel
  • Add Outline to Data in Excel
  • Conditional Formatting Data bars Examples in Excel
  • How To Filter Data in Excel
  • How to count table columns in Excel

References

  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • Excel Advanced Lookup using Index and Match Functions
  • How to use Excel INDIRECT Function
  • Count rows with at least n matching values
  • How to use Excel LOOKUP Function

Data Validations

  • Excel Data validation allow weekday only
  • Excel Data validation whole percentage only
  • Excel Data validation require unique number
  • Excel Data validation number multiple 100
  • Excel Data validation with conditional list

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

  • IF with boolean logic in Excel
  • OR function Examples in Excel
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • How to return blank in place of #DIV/0! error in Excel
  • How to use Excel OR Function

Date Time

  • Get age from birthday in Excel
  • Get days before a date in Excel
  • Add days exclude certain days of week in Excel
  • Convert decimal seconds to Excel time
  • Convert Excel time to decimal minutes

Grouping

  • Group numbers at uneven intervals in Excel
  • Running count group by n size in Excel
  • Calculate conditional mode with criteria in Excel
  • Categorize text with keywords in Excel
  • Group arbitrary text values in Excel

General

  • How to Create Calendar in Excel
  • Basic numeric sort formula in Excel
  • Count cells that do not contain errors in Excel
  • How to get original price from percentage discount in Excel
  • Delete Blank Rows at Once in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning