## How to Counting Non-Blank Cells Formula

Goal: Counting Non-Blank Cells. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003

## How to Counting Blank Cells Formula

Goal: Counting Blank Cells. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003

## Combining Cell Contents Formula

Goal: Combining a list of last names in column A, a list of first names in column B, and a list of titles (Mr., Ms., Dr., etc.) in column C. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003

## Excel’s Text Functions (24 Formulas)

Goal: Take text formulas to a more useful level by giving you numerous ways to manipulate strings. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003

## How to Using the IF( ) Formula

Goal: Mastering the powerful IF() function. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003

## How to Using the AND( ) Formula

Goal: How to perform an action if and only if two conditions are true. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003

## Using the OR( ) Formula

OR(logical1, [logical2, ...]) =IF(OR(A1>0, B1>0), “100″, “You got no bonus!”)

## VLOOKUP( ) Formula

Example: =VLOOKUP(C7,A2:B6,2,0) Explanation: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

## The MATCH( ) and INDEX( ) Formula

Goal: Using the MATCH( ) function looks through a row or column of cells for a value and combine it with the INDEX( ) function that returns the value of a cell at the intersection of a row and column inside a reference. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003

## How to Advance Vlookup to Ignore Extra Spaces Have Been Put Before, in the Middle and After Each name

Summary: How to Advance Vlookup to Ignore Extra Spaces Have Been Put Before, in the Middle and After Each name. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007 Attachments Vlookup Trim Space (13.5 KB)

Recent Comments