First formulas practice exercises
A formula is how a spreadsheet does the math for you. Write your first ones here, add, multiply and click cells into a formula, with each idea explained before you try it.
How to write a formula in Excel
A formula is an instruction that tells the spreadsheet to calculate something. It always starts with an equals sign, followed by numbers, cell references and operators: + to add, - to subtract, * to multiply, / to divide and ^ for powers. A reference like B2 means the formula reads whatever is in that cell, so when the number changes, the result updates by itself.
=B2+B3 adds the price of the coffee in B2 and the price of the cake in B3, and =B2*C2 multiplies the units in B2 by the price in C2. You can type the references or click the cells while you write the formula. Clicking is faster and avoids typos.
Excel does multiplication and division before addition and subtraction, so =B2+C2*D2 multiplies C2 by D2 first. Put the addition in parentheses, =(B2+C2)*D2, and it happens first. If a formula shows up as text instead of a number, it is missing the equals sign or the cell is formatted as Text. The exercises below cover adding two cells, multiplying quantity by price, clicking cells into a formula and using parentheses.
- 1Add two cellsIn B4, write a formula that adds the price of the coffee and the cake.
- 2Multiply quantity by priceIn D2, multiply the number of units by the price.
- 3Click cells into a formulaIn B5, add up the visitors for the three weeks by clicking the cells into your formula.
- 4Parentheses change the orderIn E2, work out the total: the units plus the bonus units, all times the price. Write (B2+C2)*D2 with the addition in parentheses, so it happens first.
Read the guide
Questions
Why does my Excel formula show as text instead of a result?
Usually the cell is formatted as Text, or a space or an apostrophe sits in front of the equals sign. Change the format to General, click into the cell and press Enter. Also check that the formula starts with =. A formula that starts any other way is treated as plain text and never calculated.
How do I add up a column of numbers in Excel?
Use SUM. =SUM(B2:B10) adds every number from B2 to B10. The quickest way on Windows is to select the empty cell under the numbers and press Alt+=, and Excel types the formula for you. You can also write =B2+B3+B4, but that gets slow and error-prone with a long list.
How do I copy a formula to the cells below?
Select the cell and drag the fill handle, the small square in its bottom-right corner, down over the rows. Double-click the handle to fill as far as the neighboring column has data. Ctrl+D also fills a selection downward. The references move with each row, so =B2*C2 becomes =B3*C3 in the next row.