Building Formulas in Excel 2013

Sorted by:  

Excel Order of Operations to Keep in Mind

Mathematics dictates a protocol of how formulas are interpreted, and Excel follows that protocol. The following is the order in which mathematical operators and syntax are applied both in Excel and in [more…]

Excel Cell References Worth Remembering

In Excel formulas, you can refer to other cells either relatively or absolutely. When you copy and paste a formula in Excel, how you create the references within the formula tells Excel what to change [more…]

How to Change Relative Formulas to Absolute Formulas in Excel 2013

All new formulas you create in Excel 2013 naturally contain relative cell references unless you make them absolute. Because most copies you make of formulas require adjustments of their cell references [more…]

Operators for Building Formulas in Excel 2013

Many of the simpler formulas that you build require the sole use of Excel’s operators, which are the symbols that indicate the type of computation that is to take place between the cells and/or constants [more…]

How to Use Excel's Insert Function Button

Excel 2013 supports a wide variety of built-in functions that you can use when building formulas. Of course, the most popular built-in function is by far the SUM function, which is automatically inserted [more…]

What Are Array Formulas in Excel 2013?

An array formula in Excel 2013 (and other spreadsheets) is a special formula that operates on a range of values. If a cell range supplies this range (as is often the case), it is referred to as an [more…]

How to Build Array Formulas in Excel 2013

To get an idea of how you build and use array formulas in an Excel 2013 worksheet, consider the sample worksheet. This worksheet is designed to compute the biweekly wages for each employee. It will do [more…]

How to Use Names in Building Formulas in Excel 2013

After you assign a name to a cell or cell range in your Excel 2013 worksheet, you can then choose the range name from the Use in Formula button’s drop-down menu on the Ribbon’s Formulas tab to paste it [more…]

How to Add Linking Formulas to Excel 2013 Worksheets

Linking formulas are formulas that transfer a constant or other formula to a new place in the same worksheet, same workbook, or even a different workbook without copying it to its new location. When you [more…]

Circular References in Excel 2013

A circular reference in an Excel 2013 formula is one that depends, directly or indirectly, on its own value. The most common type of circular reference occurs when you mistakenly refer in the formula to [more…]

How to Control Formula Recalculation in Excel 2013

Normally, Excel 2013 recalculates your worksheet automatically as soon you change any entries, formulas, or names on which your formulas depend. This system works fine as long as the worksheet is not too [more…]

Excel Dashboards and Reports: List Box Example

One of the more useful ways to use a list box in your Excel dashboards and reports is to control multiple charts with one selector. The following figure illustrates an example of this. As a region selection [more…]

Sign Up for RSS Feeds

Computers & Software