Basic Formulas At their most basic, Excel formulas can perform basic math functions and display a solution. For example, the formula "=2+2" will display "4" in the cell.

=SUM () The first function anyone should know tells Excel to carry out basic arithmetic. Let’s say you wanted the numbers in cell A2 and cell B2 to be added together in cell C2. All you’d do ...

Excel provides numerous mathematical functions to calculate values in your spreadsheet. The mathematical function to multiply values is the PRODUCT () function.