Functions

Discover how functions in Excel help you save time.
10 Pins568 Volgers
We make monthly payments, so we use 6%/12 = 0.5% for Rate and 20*12 = 240 for Nper (total number of periods). The monthly payment equals $1,074.65.

We make monthly payments, so we use 6%/12 = 0.5% for Rate and 20*12 = 240 for Nper (total number of periods). The monthly payment equals $1,074.65.

The VLOOKUP function looks for the ID (104) in the leftmost column of the range $E$4:$G$7 and returns the value in the same row from the third column (third argument is set to 3). The fourth argument is set to FALSE to return an exact match or a #N/A error if not found.

The VLOOKUP function looks for the ID (104) in the leftmost column of the range $E$4:$G$7 and returns the value in the same row from the third column (third argument is set to 3). The fourth argument is set to FALSE to return an exact match or a #N/A error if not found.

To sum cells based on multiple criteria (for example, blue and green), use the SUMIFS function (first argument is the range to sum).

To sum cells based on multiple criteria (for example, blue and green), use the SUMIFS function (first argument is the range to sum).

The IF function returns Correct because the value in cell A1 is higher than 10.

The IF function returns Correct because the value in cell A1 is higher than 10.

To create an absolute reference to cell H3, place a $ symbol in front of the column letter and row number of cell H3 ($H$3) in the formula of cell E3. Now we can quickly drag this formula to the other cells. The reference to cell H3 is fixed (when we drag the formula down and across). As a result, the correct lengths and widths in inches will be calculated.

To create an absolute reference to cell H3, place a $ symbol in front of the column letter and row number of cell H3 ($H$3) in the formula of cell E3. Now we can quickly drag this formula to the other cells. The reference to cell H3 is fixed (when we drag the formula down and across). As a result, the correct lengths and widths in inches will be calculated.

By default, Excel uses relative reference. For example, cell D2 references (points to) cell B2 and cell C2. Now, select cell D2, click on the lower right corner of cell D2 and drag it down to cell D5. Cell D3 references cell B3 and cell C3. Cell D4 references cell B4 and cell C4. Cell D5 references cell B5 and cell C5. In other words: each cell references its two neighbors on the left.

By default, Excel uses relative reference. For example, cell D2 references (points to) cell B2 and cell C2. Now, select cell D2, click on the lower right corner of cell D2 and drag it down to cell D5. Cell D3 references cell B3 and cell C3. Cell D4 references cell B4 and cell C4. Cell D5 references cell B5 and cell C5. In other words: each cell references its two neighbors on the left.

Excel displays the #VALUE! error when a formula has the wrong type of argument.

Excel displays the #VALUE! error when a formula has the wrong type of argument.

To average cells based on one criteria, use the AVERAGEIF function. For example, to calculate the average excluding zeros.

To average cells based on one criteria, use the AVERAGEIF function. For example, to calculate the average excluding zeros.

To count cells based on one criteria (for example, higher than 9), use the COUNTIF function.

To count cells based on one criteria (for example, higher than 9), use the COUNTIF function.

This array formula finds the greatest progress.

This array formula finds the greatest progress.

Pinterest
Zoeken