# Functions

12 Pins627 Volgers

### Lookup & Reference Functions in Excel

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.

### Logical Functions in Excel

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

### Financial Functions in Excel

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.

### Count and Sum Functions in Excel

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

### Statistical Functions in Excel

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

### Formula Errors in Excel

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

### Cell References in Excel

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.

### Cell References in Excel

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.

### Array Formulas in Excel

This array formula finds the greatest progress.

### Count and Sum Functions in Excel

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

### Lookup & Reference Functions in Excel

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.

### Count and Sum Functions in Excel

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

### 20 Tricks That Can Make Anyone An Excel Expert

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