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.

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