Using formulas in Excel is pretty simple. To get started, click on the cell where you want the result to appear, type an equal sign (=), then enter your formula (like =A1+B1), and press Enter.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

Note that the walkthrough and video were made using Microsoft Excel 365 for Pcs. Other versions of Excel may work differently. Excel’s auditing tools are found, fittingly enough, on the Formulas tab ...

Now, let’s create a formula in cell G2 that will populate all amounts to be financed by selecting all selling prices and subtracting all down payments. The formula is =B2:B10-F2:E10 or =B2:B10F2#.