Donate SIGN UP

Microsoft Excel

Avatar Image
drwhofan | 11:49 Wed 18th Oct 2006 | Technology
3 Answers
Which formulas are there (and what are they) to use when working with spreadsheets in Excel? I'm particularly looking for adding, subtracting, multiplying, averages etc. Thankyou!
Gravatar

Answers

1 to 3 of 3rss feed

Best Answer

No best answer has yet been selected by drwhofan. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Assuming you have a number in box A1 and a number in box A2:

Adding is =A1+A2 or =SUM(A1:A2)

Subtracting is =A1-A2

Multiplying is =A1*A2

Average would be =A1+A2/2 or =SUM(A1:A2)/2

You can either type in the box number or select it with the mouse.
to calculate average


formula is =average(A5:A25) where A5:A25 is the cell range of the amounts you want to average

From the Insert menu - select function.

From the select a category menu - select All - This will let you see what is available.

1 to 3 of 3rss feed

Do you know the answer?

Microsoft Excel

Answer Question >>