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

Data Analysis

  • Chart Axes in Excel
  • Excel Line Chart
  • Use Data Form to input, edit and delete records in Excel
  • Filter Data Based on Date in Excel
  • How To Filter Data in Excel

References

  • Two-way lookup with VLOOKUP in Excel
  • How to get last row in text data in Excel
  • Left Lookup in Excel
  • How to use Excel VLOOKUP Function
  • Vlookup Examples in Excel

Data Validations

  • Excel Data validation must not contain
  • Excel Data validation only dates between
  • Excel Data validation specific characters only
  • Excel Data validation date in next 30 days
  • Excel Data validation whole percentage only

Tag: FLOOR function

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

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

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

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

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

  • Invoice status with nested if in Excel
  • Complete List of Excel Logical Functions, References and Examples
  • Excel If, Nested If, And/Or Criteria Examples
  • Check multiple cells are equal in Excel
  • OR function Examples in Excel

Date Time

  • Convert date to Julian format in Excel
  • Basic timesheet formula with breaks in Excel
  • Check If Two Dates are same month in Excel
  • Generate series of dates by weekends in Excel
  • Display Days until expiration date in Excel

Grouping

  • Group arbitrary text values in Excel
  • Group numbers with VLOOKUP in Excel
  • Group times into unequal buckets in Excel
  • Map inputs to arbitrary values in Excel
  • Running count group by n size in Excel

General

  • AutoRecover file that was never saved in Excel
  • Subtotal by invoice number in Excel
  • Lock Cells in a Worksheet Excel
  • Using Existing Templates in Excel
  • Find Most Frequently Occurring Word in Excel Worksheet
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning