Formulas

Hi Richard,

My name is Simon and I am a trainer with Best STL.

Thank you for your question. You do not always have to use SUM after the = when creating formulae.

You need an equals sign at the beginning of every formula. If you are creating a formula that adds, divides, subtracts or multiplies two or more cells then you would start the formula with an equals sign.

=b7*c8 or =b7/c8 or =b7-c8 or =b7+c8

If you are trying to add up or average a range of cells then you could type the following:

=sum(a1:a9) or =average(b1:b9)

I hope this explanation makes it clearer for you.

Regards

Simon