خريد و فروش

Microsoft Excel software has attracted many enthusiasts due to its very special features in the administrative department. Excel software has facilitated many things with its formula writing capability. Functions are part of Excel formulas. Excel software has many functions that speed up and make things easier. In this article, we will try to introduce you some of the most used functions of Excel software.
Definition of function and its types in Excel softwareAs mentioned before, the function is a part of the formula expression in Excel that performs a specific operation.
In fact, it can be said that functions in Excel are created in two ways:
Internal functionsFunctions created by Excel software users.Of course, you should know that the Excel software has many functions in itself that it can be roughly said that there is no need to define the function on your part.
The function is a part of writing formulas in Excel.The function is a part of writing formulas in Excel.
Functions in Soft Excel are divided into several groups, including:
Financial functionsDate and time functionsMathematical and trigonometric functionsString functionslogical functionsStatistical functionsSearch and reference functionsDatabase functionsInformation check functionsBusiness intelligence functionsEngineering functionsUsers should know that the correct use of functions in Excel formulas requires skill that can be obtained with a lot of practice.
What parts does the function consist of?The function consists of two components:
Name of the function: The name of the function actually represents the operation that the function performs. In some cases, it is an abbreviation of a word.Function arguments: are the inputs of a function and are marked with ; are distinguished from each other.The arguments of a function in Excel include the following three categories:
No argumentContains a specified number of argumentsIt has 255 argumentsFunctions without arguments
We mentioned that some functions have no input. This function has no input. But remember that the parentheses () must be written after the function name. Like the function PI(), Rand which shows a random number between zero and one and the number pi 14.3, respectively.
Functions with specific arguments
As the name of the function states. They have a certain number of entries and a change in the number of entries will cause errors. Example:
The MOD() function has two arguments and the operation it performs is dividing the remainder of the first number by the second number.
Functions have 255 arguments
This function has a maximum of 255 entries. Having 255 arguments does not mean having 255 houses, but it states that this function can take a house or a range of houses as input.
Example: SUM is a very widely used function. Suppose you want to sum the values in the houses B1 to B7 together. Three modes can be considered for this operation, which are:
  The function contains one argument. (SUM (B1:B7The function contains two arguments. (SUM (B1:B3;B4:B7The function contains three arguments. (SUM (B1:B2; B3:B5; B6:B7In order to properly use functions in Excel software, you must acquire sufficient skills in using functions. Tehran Technical Complex is trying to help dear users in this matter by teaching Microsoft Office Excel 2016 course and Microsoft Office Excel Expert 2016 course.

source: excelrow.com