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.

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.

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.

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.