Today we looked at how spreadsheets use formula. Every spreadsheet formula must start with an equals sign (=), this tells the spreadsheet application to treat the cell contents as a formula.
We use the following mathematical formula in spreadsheets
- Add +
- Subtract –
- Multiply *
- Divide /
The rules of BODMAS apply for complex mathematical conditions
- =A1*A5
- =A1*A5 + 5
- =A1*(A5+5)
