Formulas

View:

Sorted by:

Looking Up Data in Excel 2007 with HLOOKUP and VLOOKUP

The most popular of the lookup functions in Excel 2007 are HLOOKUP (for Horizontal Lookup) and VLOOKUP (for Vertical Lookup). These functions are located in the Lookup & Reference category on the Formulas [more…]

Using Logical Functions in Excel 2007 Formulas

Excel 2007 uses seven logical functions — AND, FALSE, IF, IFERROR, NOT, OR, and TRUE — which appear on the Logical command button’s drop-down menu on the Formulas tab of the Ribbon. All the logical functions [more…]

Adding Up with Excel 2007's SUM and SUMIF Functions

In Excel 2007, you use the very familiar SUM function to total values in your worksheets. Use the SUMIF function when you want to total only the numbers in a range that meet a criteria you specify. These [more…]

Counting Cells with Excel 2007's COUNT Functions

Excel 2007 offers an assortment of counting functions — including COUNT, COUNTA, COUNTBLANK, and COUNTIF — in the Statistical category that enable you to count the number of cells that contain numeric [more…]

How to Display All Formulas in an Excel 2007 Worksheet

In Excel 2007, it can be difficult to view your formulas without accidentally editing them. That’s because anytime you are in “edit” mode and the active cell has a formula, the formula might incorporate [more…]

Using Absolute and Relative References in Excel 2007 Formulas

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

Understanding Excel 2007's Formula Error Values

If Excel 2007 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…]

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

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

How to Build an Array Formula in Excel 2007

Remember that an array formula is a special formula that operates on a range of values. When you build an array formula in a worksheet, you use the Ctrl+Shift+Enter keyboard shortcut to insert an array [more…]

Inserting Subtotals in an Excel 2007 Worksheet

You can use Excel 2007’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…]

Switching Vertical and Horizontal Data with Excel 2007's TRANSPOSE Function

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

How to Build Excel 2007 Formulas with the Insert Function Dialog Box

The Insert Function dialog box in Excel 2007 is designed to simplify the task of using functions in your worksheets. The dialog box not only helps you locate the proper function for the task at hand but [more…]

How to Print Formulas in an Excel 2007 Worksheet

A basic printing technique you may need in Excel 2007 is how to print the worksheet formulas instead of printing the calculated results of the formulas. You can check over a printout of the formulas in [more…]

Deconstructing Dates in Excel 2007 with DAY, WEEKDAY, MONTH, and YEAR

The DAY, WEEKDAY, MONTH, and YEAR date functions in Excel 2007 all return parts of the date serial number that you specify as their argument. You can access these functions on the Date & Time command button’s [more…]

Figuring Out the Excel 2007 Formula Bar

The Formula bar in Microsoft Office Excel 2007 displays the cell address and the contents of the current cell. Use the Formula bar to enter or edit formulas and cell entries and assign names to cells. [more…]

Calculating Loan Payments with Excel 2007's PMT Function

Excel 2007's PMT function calculates the periodic payment for an annuity, assuming a stream of equal payments and a constant rate of interest. The PMT function uses the following syntax: [more…]

Using Functions in Excel 2007 Formulas

In Excel 2007, functions are like built-in formulas that perform simple to complex tasks. For example, the SUM function sums up numbers, the COUNT function counts, and the AVERAGE function calculates an [more…]

Fixing Broken Formula Links in Excel 2007

Formulas in Excel 2007 can reference external workbooks. Links become broken when external workbooks are moved, deleted, or renamed. When a workbook that contains an external reference is opened but cannot [more…]

Powers and Roots in Excel 2007: The POWER and SQRT Functions

In Excel 2007, you use the POWER function to raise a number to a certain power, and SQRT to find the square root of a number. These functions are located with the Math & Trig functions on the Ribbon’s [more…]

Planning Ahead with Excel 2007's TODAY, DATE, and DATEVALUE Functions

Excel 2007 contains a number of built-in date functions that you can use in your worksheets. Three common date functions are TODAY, DATE, and DATEVALUE, and they can come in very handy when you're trying [more…]

Fixing Capitalization with Excel 2007's UPPER, LOWER, and PROPER Functions

Excel 2007 includes several Text functions (such as UPPER, LOWER, PROPER, VALUE, TEXT, and DOLLAR) that enable you to perform operations on text entries in a worksheet. These functions are located in the [more…]

Examining Investment Value with Excel 2007's PV and FV Functions

The most common financial functions in Excel 2007 — PV (Present Value) and FV (Future Value) — use the same arguments. The key to using these financial functions is to understand the terminology used by [more…]

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

Linking formulas are formulas in Excel 2007 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…]

Crunching Numbers with Excel 2007's AVERAGE, MAX, MIN, and MEDIAN Functions

Excel 2007's Statistical functions — including AVERAGE, MAX, MIN, and MEDIAN — are found on a continuation menu accessed from the More Functions command button’s drop-down menu on the Formulas tab. Excel [more…]

Planning Your Day with Excel 2007's NOW, TIME, and TIMEVALUE Functions

Excel 2007's time functions enable you to convert text entries representing times of day into time serial numbers so that you can use them in calculations. Some common time functions include NOW, TIME, [more…]

Listings:1-2526-50 51-51

Related Topics