Contents
In the Excel program, developers have a huge number of different functions, but users most often use mathematical ones. Let’s take a look at them and take a closer look at the most popular ones.
Using Math Functions in a Program
The category of mathematical functions includes more than 60 different operators that allow you to perform various calculations.
You can insert a function into a free table cell in different ways:
- Press the button “Insert function” (fx) to the left of the formula bar. You can perform this action from any tab.
- Switch to tab “Formulas”. There is also a button “Insert function” – in the left corner of the toolbar.
- Press the key combination Shift + F3, to call Function wizard.
The result of any of the above methods will open the insert function window. Here we select a category “Mathematical”.
Now that the category is selected, check the required function in the box below and click OKAY.
After that, a window with arguments to fill in will open.
Note: If we, being in the tab “Formulas”, in the tool group “Function Library” click on the icon of mathematical functions, a list of operators will immediately open, which we can select, bypassing the function insertion window.
It should be borne in mind that not all operators are present in the proposed list, but the most necessary ones are still there, and in most cases they are enough.
Now let’s move on to a detailed review of the most popular features.
SUM
Perhaps this is the most popular function that is used in Excel. It is used to sum up numerical data. Function formula:
=СУММ(число1;число2;...)
In arguments, you can specify both specific numbers and cell references containing numeric values. Moreover, you can specify the coordinates manually (using the keyboard keys) or by clicking / highlighting directly in the table itself.
To proceed to filling in the next argument, just click on the field opposite it or press the key Tab.
SUMMESLI
This function allows you to calculate the sum of numbers with specified conditions, with the help of which the selection of values taken into account in the summation will be performed. The formula looks like this:
=СУММЕСЛИ(Диапазон;Критерий;Диапазон_суммирования)
The function arguments specify the range of cells (manually or by selecting in the table), the values of which are to be summed. As a criterion, you can specify the following conditions (in quotes):
- more (“>”)
- less than (“<“)
- not equal (“<>”)
Argument “Sum_Range” not required to fill out.
PRODUCT
This operator is used to multiply numbers. The syntax looks like this:
=ПРОИЗВЕД(число;число;…)
In function arguments, as in SUM, you can specify both specific numbers and cell addresses (ranges of cells) that contain numeric values.
PRIVATE
The most commonly used formula for division is a signed formula. “/” between dividend and divisor: =Число1/Число2.
However, the program also has a separate function for performing division, the syntax of which is shown below:
=ЧАСТНОЕ(Числитель;Знаменатель)
You need to fill in two arguments: Numerator (Divisible) и Denominator (Divisor).
POWER
The operator allows you to raise a number to a specified power. The formula looks like this:
=СТЕПЕНЬ(число;степень)
The function arguments specify the number itself, as well as the power to which it needs to be raised.
ROOT
This operator can be used to extract the square root of a number. The syntax looks like this:
=КОРЕНЬ(число)
Only one argument is required to fill – “Number”.
ROUNDWOOD
The function is used to perform another common mathematical operation – rounding numbers (according to general mathematical rules, i.e., to the nearest value in absolute value). The syntax of the function is given below:
=ОКРУГЛ(число;число_разрядов)
In argument “Number” specifies the value to be rounded. In the number of digits, respectively, we write the number of digits that we want to leave after the decimal point.
Also, operators are available in Excel KRUGLVVERH и ROUND DOWN, which, as their names suggest, are used to round to the nearest upper and lower number, respectively (modulo).
ABS
Allows you to get the modulus of a number. The function formula is shown below:
=ABS(число)
You only need to fill in one argument – “Number”The whose modulus is to be found.
LOG
This operator determines the logarithm of a number with respect to a given base. The function syntax is presented as:
=LOG(Число;Основание)
You need to fill in two arguments: Number и Base logarithm (if you do not specify it, the program will take the default value of 10).
Also, for the decimal logarithm, a separate function is provided – LOG10.
RESIDUE
It is used to get the remainder after dividing numbers. The operator formula looks like this:
=ОСТАТ(чило;делитель)
In order to get the result, you need to fill in the values of two arguments: Number и Divider.
Conclusion
Thus, we have analyzed the most popular mathematical functions that are used in Excel. However, the capabilities of the program are much wider, and in its toolkit you can find a function for the successful completion of almost any task.