Excel 2013 Formulas & Functions

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…]

Excel Functions You're Likely to Use

Some Excel functions apply to specific subject areas, but others are general and apply to all needs. The following list shows an array of Excel functions used by one and all. Check here for a quickie reference [more…]

Excel Text Functions You'll Find Helpful

Excel's text functions are very helpful when you're working with names, addresses, customer lists, or any other text-based data. Here is list of Excel functions associated with text, along with a description [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…]

How to Enter a Formula Using Cell Names in Excel 2013

Cell names are a great way to make out the purpose of your formulas in Excel 2013. For example, suppose that you have a simple formula in cell K3 that calculates the total due to you by multiplying the [more…]

How to Create a Constant Formula in Excel 2013

Certain formulas in Excel 2013 use constant values, such as an 8.25% tax rate or a 10% discount rate. If you don’t want to have to enter these constants into a cell of the worksheet in order to use the [more…]

Deciphering Error Values in Excel 2013 Formulas

You can tell right away that an Excel 2013 formula has gone haywire because instead of a nice calculated value, you get a strange, incomprehensible message. This weirdness is, in the parlance of Excel [more…]

How to Describe a Custom Excel 2013 Function

To help your user understand the purpose of your custom functions in Excel 2013, you can add descriptions that appear in Insert Function and Function Arguments dialog boxes that help explain what the function [more…]

The PMT Function in Excel 2013

The Excel 2013 PMT function on the Financial button’s drop-down menu on the Formulas tab of the Ribbon calculates the periodic payment for an annuity, assuming a stream of equal payments and a constant [more…]

Analysis ToolPak Add-In Financial Functions

By activating the Analysis ToolPak add-in with Excel 2013, you add a whole bunch of powerful financial functions to the Financial button’s drop-down menu on the Formulas tab of the Ribbon. The table shows [more…]

How to Round Off Numbers in Excel 2013

In Excel 2013 you use the ROUND function found on the Math & Trig command button’s drop-down menu to round up or down fractional values in the worksheet as you might when working with financial spreadsheets [more…]

How to Use Conditional Summing in Excel 2013

The SUM function in Excel 2013 is perfect when you want to get the totals for all the numbers in a particular range or set of ranges. But what about those times when you only want the total of certain [more…]

Look Up a Single Value with VLOOKUP and HLOOKUP in Excel

The most popular of the lookup functions in Excel 2013 are HLOOKUP (for Horizontal Lookup) and VLOOKUP (for Vertical Lookup) functions. These functions are located on the Lookup & Reference drop-down menu [more…]

How to Perform a Two-Way Lookup in Excel 2013

You may have a table in Excel 2013 in which you need to perform a two-way lookup, whereby a piece of data is retrieved from the Lookup table based on looking up a value in the top row [more…]

How to Transpose Cell Ranges in Excel 2013

The TRANSPOSE function in Excel 2013enables you to change the orientation of a cell range (or an array). You can use this function to transpose a vertical cell range where the data runs down the rows of [more…]

How to Get Specific Information About Cells in Excel 2013

The CELL function in Excel 2013 is the basic information function for getting all sorts of data about the current contents and formatting of a cell. The syntax of the CELL function is [more…]

How to Use Text Functions in Excel 2013

Text functions in Excel 2013 are found on the Text command button’s drop-down menu on the Ribbon’s Formulas tab (Alt+MT). There are two types of text functions: functions such as VALUE, TEXT, and DOLLAR [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…]


Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com