Basics of Mathematical Formulas
|
We also have Free
training videos on this site ( visit the
Home page
or the
Training Page)
Mathematical formulas in Excel can be described as entries with an equation to calculate the value which the user wants to be displayed in the worksheet. Instead of typing in the numbers, the mathematical formulas are used – thus the equations.
|
|
Some basics you should know about mathematical formulas in Excel are explained below.
The equal sign
The function always start with the equal = sign followed directly by the equation.
Constants
The above term refers to something that is fixed whether displayed as a currency, percentage or number. Formatting is used to get to the display form for instance R1000.00. The user types in the numbers and not R before the number. The formatting will automatically display the Rand currency.
References
Rather than typing in equations every time, it is better to make use of references. An example will thus look like this:
= C1* C2
|
|
The divide sign
The forward slash is used in equations to indicate division for example:
=B6/B2
Multiplication sign
In Excel the asterisk * is used to indicate multiplication. An example will look like this:
= 5 * 6 (which means 5 times 6)
If we were to refer we would use for example =A2 * B2.
Addition sign
In Excel the + sign is used to add totals up. For example:
= A7+B7
Subtraction sign
The minus function is indicated by – and looks for example like this:
=C3-C2.
To locate more advanced information regarding mathematical formulas in Excel, use our training index.
|
