# Functions

**12**Pins

**627**Volgers

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 IF function returns Correct because the value in cell A1 is higher than 10.

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.

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

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

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

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.

This array formula finds the greatest progress.

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

##### Meer ideeën

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 count cells based on one criteria (for example, higher than 9), use the COUNTIF function.

One Click to Select All

Excel can be Exciting : 15 Fun things to do with Microsoft Excel | Chandoo.org - Learn Microsoft Excel Online

Frequently Asked Questions about OneNote 2016 for Windows My version of OneNote doesn't match the help topics I'm reading. What's going on?

Calculate The Number Of Days, Months Or Years Between Two Dates - FREE Microsoft Excel Spreadsheet Tips and Tutorials

Life Hacks - Excel file too big.

Free Word 2013 Cheat Sheet http://www.customguide.com/cheat_sheets/word-2013-cheat-sheet.pdf

Excel 2013 is the spreadsheet application in Microsoft's new Office 2013. This free tutorial from @GCFLearnFree.org will show you how to use the powerful tools in Excel 2013 for organizing, visualizing, and calculating your data. #Excel #technology

10 Excel Secrets Every Admin Should Know - Admin Secret