Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas
Formulas
Resolved · Low Priority · Version 2003
For upcoming training course dates see: Pricing & availability
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:
http://www.microsofttraining.net/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.
|
