When solving equations or constructing formulas in a
spreadsheet like Microsoft Excel, you need to ensure that the equation
or formula is solved in the correct order. If the formula or
equation is not solved in the correct order, you may find the result
you get, is not the result you were looking for.
Worse still this can result in a miscalculation that
may even cost you money, something that no business can afford in the
competitive market our modern companies trade in.
I have found during the years I have taught Microsoft
Excel that a large percentage of people do not understand how to solve
long mathematical equations correctly.
This page is dedicated to helping people to learn the
skills required to create and test formulas in a spreadsheet like
The rules are as follows. Note: you can test
these out in Excel by, SELECTING a blank cell, then PRESS
= (equals) on the keyboard followed by the equation. PRESS
the Enter key on the keyboard or CLICK the OK button in Excel to
accept your calculation (formula).