View:
Sorted by:
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…]
White-Out Errors with Conditional Formatting in Excel 2013
Instead of creating logical formulas in Excel 2013 to suppress the display of potential error values, you can use Conditional Formatting to deal with them. All you have to do is create a new conditional [more…]
Excel 2013's Formula-Auditing Tools
Excel 2013 offers some very effective formula-auditing tools for tracking down a cell that’s causing your error woes by tracing the relationships between the formulas in the cells of your worksheet. By [more…]
Error-Checking Options in Excel 2013
When you choose Error Checking Options from the alert options drop-down menu attached to a cell with an error value or click the Options button in the Error Checking dialog box, Excel 2013 opens the Formulas [more…]
Time Functions in Excel 2013
Excel 2013 offers far fewer Time functions when compared with the wide array of Date functions. Like the Date functions, however, the Time functions enable you to convert text entries representing times [more…]
Special Date Functions in Excel 2013
Excel 2013 includes other special Date functions in the Date and Time category in the Insert Function dialog box. These particular Date functions expand your abilities to do date calculations in the worksheet [more…]
How to Calculate the Present Value in Excel 2013
The PV (Present Value) function in Excel 2013 is found on the Financial button’s drop-down menu on the Ribbon’s Formulas tab (Alt+MI). The PV function returns the present value of an investment, which [more…]
How to Calculate the Net Present Value in Excel 2013
The Net Present Value (NPV) function in Excel 2013 calculates the net present value based on a series of cash flows. The syntax of this function is [more…]
How to Calculate the Future Value in Excel 2013
The Future Value (FV) function in Excel 2013 is found on the Financial button’s drop-down menu on the Ribbon’s Formulas tab (Alt+MI). The FV function calculates the future value of an investment. The syntax [more…]
How to Use the Database Functions in Excel 2013
Excel 2013 includes a number of database functions that you can use to calculate statistics, such as the total, average, maximum, minimum, and count in a particular field of the data list only when the [more…]
