Excel 2010 Formulas & Functions

Sorted by:  

Rounding Numbers in Excel 2010 with ROUND, ROUNDUP, and ROUNDDOWN

The mathematical functions ROUND, ROUNDUP, and ROUNDDOWN are included in the Math & Trig category in Excel 2010. You'll find these by clicking the Math & Trig button on the Ribbon's Formulas tab or in [more…]

How to Install the Excel 2010 Analysis ToolPak

The Analysis ToolPak is an Excel 2010 add-in program that adds extra financial, statistical, and engineering functions to Excel's pool of built-in functions. The tools included in the Analysis ToolPak [more…]

How to Enter Basic Formulas in Excel 2010

Formulas are the real workhorses of an Excel 2010 worksheet. If you set up a formula properly, it computes the correct answer when you enter it into a cell. From then on, it keeps itself up to date, recalculating [more…]

Using Parentheses to Change the Order of Operations in Excel 2010 Formulas

Many formulas that you create in Excel 2010 perform multiple operations. Excel follows the order of operator precedence when performing each calculation. This natural order of arithmetic operations is [more…]

Using Absolute and Relative References in Excel 2010 Formulas

You can use three types of cell references in Excel 2010 formulas: relative, absolute, and mixed. Using the correct type of cell reference in formulas ensures that they work as expected when you copy them [more…]

How to Insert Subtotals in an Excel 2010 Worksheet

You can use Excel 2010's Subtotals feature to subtotal data in a sorted list. To subtotal a list, you first sort the list on the field for which you want the subtotals, and then you designate the field [more…]

How to Join Text Strings in Excel 2010 with the & Operator

In Excel 2010, you can use the ampersand (&) operator to concatenate (or join) separate text strings together. For example, in a client list worksheet that includes the last names in column A and the first [more…]

Referring to Values or Formulas in Other Cells in Excel 2010 Formulas

Linking formulas are formulas in Excel 2010 that reference a location in the same worksheet, same workbook, or even a different workbook. When you create a linking formula, it brings forward the constant [more…]

How to Build an Array Formula in Excel 2010

An array formula is a special formula that operates on a range of values in Excel 2010. When you build an array formula in a worksheet, you press Ctrl+Shift+Enter to insert an array formula in the array [more…]

Understanding Excel 2010's Formula Error Values

If Excel 2010 can't properly calculate a formula that you enter in a cell, the program displays an error value in the cell as soon as you complete the formula entry. Excel uses several error values, all [more…]

Understanding Excel 2010's Formula Auditing Tools

Excel 2010 offers some effective formula-auditing tools for tracking down the cell that's causing your error woes by tracing the relationships between the formulas in the cells of your worksheet. By tracing [more…]

How to Trace Precedents and Dependents in Excel 2010 Formulas

Excel 2010 formulas may contain precedents and may serve as dependents to other formulas. Precedents are cells or ranges that affect the active cell's value. [more…]

How to Check For and Evaluate Errors in Excel 2010 Formulas

The Evaluate Formula dialog box in Excel 2010 walks you through the steps used in calculating a result from a formula. This helps locate errors in formulas that are long or have precedents. For example [more…]

Dealing with Circular References in Excel 2010 Formulas

A circular reference occurs when a cell in an Excel 2010 worksheet refers to itself, whether directly or indirectly. For example, if =100+A2 is entered into cell A2, then a direct circular reference has [more…]

Creating Complex Formulas in Excel 2010

Excel can calculate complex formulas where you want to combine adding, multiplication, division, and more, but you have to write your formulas carefully so Excel understands the end result you're looking [more…]

Applying Functions in Excel 2010

Excel uses functions for math that's more complicated than simple arithmetic. Functions often use one or more cell references or ranges and can perform a wide variety of math, including calculating averages [more…]
Learning anything is easy with For Dummies eLearning!

Sign Up for RSS Feeds

Computers & Software
Enter now for a chance to win a book bundle and $100

Inside Dummies.com