Formulas - Adding, Subtracting, Multiplying and Dividing
Learn to work with data in a spreadsheet and to create engaging charts, maps and graphs in the kdmcBerkeley Data Visualization Workshop.
With a spreadsheet you can insert a formula that will instantly add, subtract, multiply or divide numbers in columns or rows.
To do this you select a cell in a new column or row and then type in a formula.
A formula starts with an equals sign (=) that tells the spreadsheet you want to do a calculation.
A formula then has a symbol for what kind of calculation you want to perform (add, subtract, multiply, divide, etc.). The symbols a spreadsheet uses for calculations are:
- plus sign (+) for adding one number to another
- minus sign (-) for subtracting one number from another
- asterisk (*) for multiplying one number by another
- backslash (/) for dividing one number by another
Then you type in the letters/numbers for the cells (A1, A2, B1, B2, etc.) to which you want to apply the calculation, separated by the symbol for the type of calculation.