Guidelines and examples of array formulas - Microsoft Support
The following examples show you how to create multi-cell and single-cell array formulas. Where possible, we’ve included examples with some of the dynamic array functions, as well as existing array formulas entered as both dynamic and legacy arrays.
Fill a formula down into adjacent cells - Microsoft Support
Simply do the following: Select the cell with the formula and the adjacent cells you want to fill. Click Home > Fill, and choose either Down, Right, Up, or Left. Keyboard shortcut: You can also press Ctrl+D to fill the formula down in a column, or Ctrl+R to fill the formula to the right in a row.
Create a 3-D reference to the same cell range on multiple …
A 3-D reference is useful and convenient way to reference several worksheets that follow the same pattern and cells on each worksheet contain the same type of data, such as when you consolidate budget data from different departments in your organization.
Move or copy a formula - Microsoft Support
Move a formula. Select the cell that contains the formula that you want to move. In the Clipboard group of the Home tab, click Cut. You can also move formulas by dragging the border of the selected cell to the upper-left cell of the paste area. This will replace any existing data.
How to correct a #VALUE! error in the DATEVALUE function
Problem: The value in the date_text argument is not in sync with the system’s date and time settings. If your system date and time settings follow the mm/dd/yyyy format, then a formula such as =DATEVALUE (“22/6/2000”) will result in a #VALUE! error.
Insert subtotals in a list of data in a worksheet - Microsoft Support
How to use the Subtotal command in Excel to calculate subtotals and grand totals in a list.
Using calculation operators in Excel formulas - Microsoft Support
There are four different types of calculation operators: arithmetic, comparison, text concatenation, and reference. Arithmetic operators. To perform basic mathematical operations, such as addition, subtraction, multiplication, or division; combine numbers; and produce numeric results, use the following arithmetic operators. Arithmetic operator ...
Use cell references in a formula - Microsoft Support
In the formula bar , type = (equal sign). Do one of the following, select the cell that contains the value you want or type its cell reference. You can refer to a single cell, a range of cells, a location in another worksheet, or a location in another workbook.
VLOOKUP function - Microsoft Support
Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID. In its simplest form, the VLOOKUP function says:
ROUND function - Microsoft Support
The ROUND function rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula: =ROUND (A1, 2) The result of this function is 23.78.
Use sparklines to show data trends - Microsoft Support
Use sparklines to show data trends. A sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values.