Simple Calculations in Microsoft Excel
In addition to doing pretty complex calculations, Excel can help you do simple arithmetic like adding, subtracting, multiplying, or dividing any of your data.
• To add, use the + sign.
• To subtract, use the – sign.
• To multiply, use the * sign.
• To divide, use the / sign.
You can also use parenthesis to ensure certain calculations are done first. In the example below (10+10*10), the second and third 10 were multipled together before adding the additional 10. However, if we made it (10+10)*10, the first and second 10 would be added together first.
Bonus: If you want the average of a set of numbers, you can use the formula =AVERAGE(Cell Range). If you want to sum up a column of numbers, you can use the formula =SUM(Cell Range).