Where Business Meets Perfection.
Follow Solfecta! Like Solfecta on Facebook! Follow Solfecta on Twitter! Follow Solfecta on LinkedIn! Follow Solfecta on Google+!

Thursday Tips and Tricks: Microsoft Excel – Simple Calculations

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).

 

 

 

Share on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

Leave a Reply