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

Data Analysis

  • Managing Conditional Formatting Rules in Excel
  • Subtotal function in Excel
  • How To Perform and Interpret Regression Analysis in Excel
  • How to create running total in an Excel Table
  • How to combine 2 or more chart types in a single chart in Excel

References

  • How to get last row in mixed data with blanks in Excel
  • Basic INDEX MATCH approximate in Excel
  • How to create dynamic named range with OFFSET in Excel
  • How to get address of named range in Excel
  • Vlookup Examples in Excel

Data Validations

  • How To Create Drop-down List in Excel
  • Excel Data validation must begin with
  • Excel Data validation allow uppercase only
  • Excel Data validation with conditional list
  • Excel Data validation no punctuation

Tag: CEILING 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 to nearest 5 in Excel

by

This tutorials shows how to Round to nearest 5 in Excel. If you need to round a number to the nearest multiple of 5, you can use the MROUND function and supply 5 for number of digits. Formula =MROUND(number,5) Explanation In the example, cell C6 contains this formula: =MROUND(B6,5) The value in B6 is 17 …

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

Next biweekly payday from date in Excel

by

To get the next payday – assuming a biweekly schedule, with paydays on Friday – you can use a formula based on the CEILING function.  Formula =CEILING(date+1,14)-1 Explanation In the example shown, the formula in C6 is: =CEILING(B6+1,14)-1 Note: this formula assumes Excel’s default 1900 date system. How this formula works This formula depends on …

Continue Reading

Running count group by n size in Excel

by

This tutorial shows how to Running count group by n size in Excel using the example below; Formula =CEILING(COUNTA(expanding_range)/size,1) > Explanation To creating a running count of groups of a variable size, you can use the COUNTA and CEILING function. In the example shown, C5 contains this formula: =CEILING(COUNTA($B$5:B5)/size,1) where “size” is the named range F4. How …

Continue Reading

Shade alternating groups of n rows in Excel

by

This tutorial shows how to Shade alternating groups of n rows in Excel using the example below; Formula =ISEVEN(CEILING(ROW()-offset,n)/n) Explanation To highlight rows in groups of “n” (i.e. shade every 3 rows, every 5 rows, etc.) you can apply conditional formatting with a formula based on the ROW, CEILING and ISEVEN functions. In the example …

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 a number up to next half in Excel

by

This tutorials shows how to Round a number up to next half in Excel. If you need to round a number up to the next half, you can use the CEILING function, which always rounds up based on a supplied multiple. Formula =CEILING(number,0.5) Note that MROUND also rounds based on a supplied multiple, but it always rounds to …

Continue Reading

Round by bundle size in Excel

by

This tutorials shows how to Round by bundle size in Excel. To round up to the next bundle size, you can use the CEILING function which automatically rounds up away from zero. To round up to the next bundle size, you can use the CEILING function which automatically rounds up away from zero. Formula =CEILING(number,bundle)/bundle …

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

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

by

What is CEILING function in Excel? CEILING function is one of the Math and Trig functions in Microsoft Excel that returns number rounded up, away from zero, to the nearest multiple of significance. For example, if you want to avoid using pennies in your prices and your product is priced at $4.42, use the formula …

Continue Reading

How to randomly assign people to groups in Excel

by

To randomly assign people to groups or teams of a specific size, you can use a helper column with a value generated by the RAND function, together with a formula based on the RANK and ROUNDUP functions. Formula =ROUNDUP(RANK(A1,randoms)/size,0) Explanation In the example shown, the formula in D5 is: =ROUNDUP(RANK(C5,randoms)/size,0) which returns a group number …

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

  • How to use Excel XOR Function
  • OR function: Description, Usage, Syntax, Examples and Explanation
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel NOT Function
  • Check multiple cells are equal in Excel

Date Time

  • NETWORKDAYS.INTL function: Description, Usage, Syntax, Examples and Explanation
  • Get first Monday before any date in Excel
  • Add workdays to date custom weekends in Excel
  • Add decimal hours to time in Excel
  • EDATE function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • Calculate conditional mode with criteria in Excel
  • Group arbitrary text values in Excel
  • Categorize text with keywords in Excel
  • Group times into unequal buckets in Excel
  • Group numbers with VLOOKUP in Excel

General

  • How to get amount with percentage in Excel
  • Convert column letter to number in Excel
  • Hide and Unhide Columns or Rows in Excel
  • Create dynamic workbook reference to another workbook in Excel
  • How to generate random times at specific intervals in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning