Formulas

Hello Bianca

Thank you for your question and welcome to the forum.

With regard to basic formulas (ref means reference):

1. All formulas start with =
2. To add cells, use =cell ref+cell ref or =sum(cell:cell) to add adjacent or =sum(cell,cell) to add non-adjacent cells
3. To subtract, =cell ref-cell ref
4. To multiply, =cell ref*cell ref
5. To divide, =cell ref/cell ref
6. =AVERAGE(cell:cell) finds the average of the cell range selected
7. You can use MIN or MAX in place of AVERAGE to find the lowest or highest value in a range, respectively.

Kind regards
Amanda