Get UNSTUCK with Expert Advice

Press Esc to close

How to insert & edit Excel formulas

To enter a formula you can either select a cell and type '=' followed by the formula, as shown here:

Or...

Select the desired cell, then click the 'formula bar' and type in the formula (starting with the obligatory '=' sign), as shown here:

Once you've entered a formula, it will not show in the cell. The cell will show the result of the formula (there's a way around this that we'll discuss later).

To edit a formula once you've created it, do one of the following:

  1. Select the cell containing the formula and then edit the formula in the 'formula bar'
  2. Select the cell and press 'F2'. This will show the formula within the cell and allow you to edit it

previous

next

Home   |   Ask a question   |   Excel Guides   |   Formula Expert Addin   |   FAQs   |   About Us