Creating Simple Formulas

When using formulas in Excel you can add, subtract, multiply, and divide. Use simple Excel formulas to also make cell references in Excel.

Simple formulas

Download the example to work along with the video.

To create a simple formula that adds two numbers:

Simple Addition Formula

If the result of a formula is too large to be displayed in a cell, it may appear as pound signs (#######) instead of a value. This means that the column is not wide enough to display the cell content. Simply increase the column width to show the cell content.

Excel will not always tell you if your formula contains an error, so it's up to you to check all of your formulas. To learn how to do this, you can read the Double-Check Your Formulas lesson from our Excel Formulas tutorial.

To create a simple formula that adds the contents of two cells:

Formula with Cell Reference

To create a simple formula using the point-and-click method:

Point and Click
Point and Click