All Formulas and Functions begin with =. It is the = sign that tells Excel it is going to be doing something mathematical. You will need to ensure you click in the cell you would like the answer to display in. The difference between Formulas and Functions is Formulas use symbols like on the calculator + – the multiply is the * and the divide is the / .
All Calculations Begin with =
= Cell Ref Operator Cell Ref
Order of Operations
Formulas are not worked on left to right as you might think. You must follow a specific order a rule. BODMAS is the acronym for what must be done first, second and third.
The BODMAS Order
B ( )
Exponential eg 3m2
Eg; 5+ 2 * 10 = 25
If you need 70 to be your answer
Add brackets to the formula
(5+2)*10 = 70
Watch this video for a demo on how to create a basic formula using Microsoft Excel.
Functions follow a structured and there are over 300 functions pre-defined in Microsoft Excel eg = sum (A1:A12) . When creating a function start with = then the function name followed by an open bracket, this bracket is important if you do not have it there is no function. Watch this video to demonstrate how to construct a basic function.
Microsoft Office Small Group Training Sessions
AZ Solutions Pty Ltd delivers customized training courses here in Sydney – Australia. We come to you. All you need is a board room, PC’s for each student and a TV/ Projector with a HDMI connection cable. In our training sessions you are welcomed to bring examples of your work to class. We prefer it.
Call Now M 0414 417 059 visit www.azsolutions.com.au