which generates this Excel spreadsheet. The bookkeeper enters a formula in column B that calculates which customers are more than 30 days past due, then sends late notices accordingly. A.

If-Then rules allow you to create colorful business ... Built-in processing logic enables Excel to apply colors to cells as you and others work with them. Launch Excel and open a spreadsheet.

All formulas in Excel start with the equal sign (=) and build from there. To add the numbers in two cells together, first click the on the target cell where you want the total to appear.

In Excel, this feature is handled by the function REPT. It’s not quite as efficient because you must add the character to the formula, then specify how many times you want that character repeated.

Numbers by themselves seldom convey the big picture. Excel Charts makes it easy to illustrate trends in your business, from past expenses and profit to sales forecasts based on previous sales.

A basic formula might look like this: =A2+B2. This basically tells Excel to add the number in cell A2 to the number in cell B2, and then show the result in the cell where you typed the formula.

Learn how to identify formula cells the easy way using VBA, and then combine VBA and conditional ... and Errors. Click OK and Excel selects cells that contain formulas. Using VBA Using the Special ...