Formulas are entries that have equations that calculate the value to display based on other cells in the spreadsheet. In the below example the formula is in the column Total Price. The formula typed into cell D2 to find the total price for apples is:


It’s important to remember to type in the cell reference instead of the constants. If I had typed in 1.99*2.4, the answer would work for that example, but I couldn’t copy and paste the formula for the rest of the produce. Also if the price per pound changed, or the weight, I would have to audit those columns AND the calculated column. BEST PRACTICE is to use cell reference.

Remember all formulas must start with an equal sign =

Data Types