CEILING function - Microsoft Support
Description. 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 =CEILING (4.42,0.05) to round prices up to the nearest nickel.
Create custom functions in Excel - Microsoft Support
Certain kinds of statements, such as statements that select and format ranges, are excluded from custom functions. In this article, you’ll learn how to create and use custom functions. To create functions and macros, you work with the Visual Basic Editor (VBE), which opens in a new window separate from Excel.
CEILING.MATH function - Microsoft Support
CEILING.MATH (number, [significance], [mode]) The CEILING.MATH function syntax has the following arguments. Number Required. Number must be less than 9.99E+307 and greater than -2.229E-308. Significance Optional. The multiple to which Number is …
Overview of formulas in Excel - Microsoft Support
A reference identifies a cell or a range of cells on a worksheet, and tells Excel where to look for the values or data you want to use in a formula. You can use references to use data contained in different parts of a worksheet in one formula or use the value from one cell in several formulas.
Freeze panes to lock rows and columns - Microsoft Support
How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
Use the Navigation pane in Excel - Microsoft Support
Find and access elements such as tables, charts, PivotTables, and images within your workbook. Once you've opened the Navigation pane, it displays on the right side of the Excel window. The Navigation pane also makes it easier for those with visual …
AGGREGATE function - Microsoft Support
Returns an aggregate in a list or database. The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and error values.
CELL function - Microsoft Support
The CELL function syntax has the following arguments: info_type values. The following list describes the text values that can be used for the info_type argument. These values must be entered in the CELL function with quotes (" "). CELL format codes.
FLOOR function - Microsoft Support
This article describes the formula syntax and usage of the FLOOR function in Microsoft Excel. Description. Rounds number down, toward zero, to the nearest multiple of significance. Syntax. FLOOR (number, significance) The FLOOR function syntax has the following arguments: Number Required. The numeric value you want to round. Significance Required.
Lookup and reference functions (reference) - Microsoft Support
Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.
Present your data in a Gantt chart in Excel - Microsoft Support
Create a Gantt chart to present your data, schedule your project tasks, or track your progress in Excel.