Spreadsheet Formulas

Spreadsheet Formulas

1. Addition

   • To add numbers the formula is =SUM(B3:B10)

2. Average

   • The formula is =AVERAGE(B3:B10)

3. Maximum

   • This is for finding the biggest number in a range of cells
   • The formula is =MAX(B3:B10)

4. Minimum

   • This is for finding the smallest number in a range of cells
   • The formula is =MIN(B3:B10)

5. Subtracting

   • The formula is =(B3-B10)

6. Multiplying

   • The formula is =(B3*B10)

7. Dividing

   • The formula is =(B3/B10)

8. Addition, Subtracting, Multiplying and Dividing are all simple formulas

9. An formula ALWAYS starts with =

10. Average, Maximum and Minimum are functions. Functions are formulas that use a key word to perform a specific calculation