formulas

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

Formulas

resolvedResolved · Low Priority · Version 2003

Aileen has attended:
Excel Intermediate course

Formulas

I would like to learn more about formulas

RE: Formulas

Hi Aileen

Thank you for your question and welcome to the forum.

We do cover how to create formulas on the Excel Introduction course, so I've included a link below so you can download our Introduction level handbook:
https://www.stl-training.co.uk/download/trainer/courseware/excel_2007_introduction.zip

Basically all formulas start with an = sign.
To add, use the SUM function =SUM() and enter the cells you wish to add together into the brackets (e.g. A2:A15).

Alternatively you can use + but I would only do this if you are adding say 2 or 3 cells together, e.g. =A1+A2+A3

To subtract use -
e.g. =A1-A2 minuses the value in cell A2 from the value in cell A1

To multiply use * (asterisk)
e.g. =A1*A2 will multiply the values in A1 and A2 together

To divide use / (forward slash)
e.g. =A1/A2 divides the value in cell A1 by the value in cell A2

I hope this helps.
Amanda

Wed 18 Feb 2009: Automatically marked as resolved.


 

Excel tip:

How to Spell Check an Excel 2010 Worksheet

Excel 2010 does not automatically spell check a document. So, here's how to manually spell check a worksheet.

Either select the ''Review'' tab in the Ribbon, go to the ''Proofing'' section and click ''Spelling.'' Or, simply press F7.

View all Excel hints and tips


Server loaded in 0.09 secs.