3.2.4. Selected functions for business purposes.


3.2.4.1. Overview of the functions.

The following overview shows, which currently features usually in tables kalkulations programs are available, although in particular. In the subsequent detaillierung those selected were required for the solution of tasks of business relevance. Current tables kalkulations programs regularly offer a multiple of functions in the various areas; they should because of the examples here learned in demand also falls under these additional functions out tion of the help function.

Financial Mathematical Functions:

= Bw. ......... Bart returns the value of an investment.
= IKV ......... Internet equity interest rates.
= LIA ......... Linear depreciation rate.
= Etc

Date Functions:

= Date ....... reckons with the day, month, year una specified date in order enine current number, you can then sangaben date.
= Today ....... returns the current date.
= Year ........ calculated from the number dder current year.
= Etc

Information functions:

= Istfehler .... returns true if the cell contains an error value, it can also query whether a cell respect (istbezug), a re except (istfehl), a text (isttext), not text (istktext) , a blank cell (istleer), a truth swert (istlog), a fehlerwert (istnv) or a number (istzahl).
Typ = ......... provides a number of the datentyp the specified value.
= Cell ....... provides information about formatting, position or content of a cell.

Mathematical and trigonometric functions:

= ABS ...... OrderForm absolutwet as a result of the number.
= ARCCOS delivers the Arkuscosinus ....
= ARCSIN delivers the arkussinus ....
= Etc.

Statistical Functions :

= NUMBER ... as a result provides the number of pay.
= ANZAHL2 .. as a result provides the number of pay, any values.
= MAX ...... supplies grisste number from the argumentliste.

Matrix functions:

= MDET ..... determinante provides a matrix.
= MINV ..... returns the inverse of a matrix.
= MMULT .... delivers the matrizen produckt.
= Etc



Text functions:

= PARTY ..... converts a number with a fixed number of comma, in a text.
= FIND ... looking for a text in a text and gives the position ¨. Large / small description will beahtet.
= GROSS .... Waldelt text in big letters.

Logical Functions :

= FALSE .... as a result provides the (wahrheits) worth wrong.
= NOT ..... returns TRUE, if the argument was false, and vice versa.
= TRUE ...... provides the true heitswert TRUE

3.2.4.3. Statische functions

The most commonly used formula is certainly the sum formula. It was therefore Excel 3.0 as a separate icon in the toolbar and click of a button can be entered.

The function returns expected, the sum total of the figures cited as arguments. In some programs, this function is designed to provide only a range argument can edit. Therefore, the formula in cell is not defined anywhere.

Figures is either a single number or a range of numbers. It can be fixed values, formulas or references to other cells can be entered. If the specified range references to cells, which do not contain figures, they are simply disregarded. Would these cells by adding operators added, it would be the result of the error value, because not all cells addiebare values.

Be texts or truth-values directly as arguments in the sum formula, then they are converted into numbers and very probably counted. TRUE will be counted as number 1, text with the appropriate numeric value. Do arguments, which are not convertible in numbers are directly as an argument in the sum formula, then the error value # VALUE.

The function NUMBER notes how many numbers in the Argumentlische contained and returns the appropriate value. Only values, the null, numbers, truth-values, datumsangaben or numbers in text form sind.Fehlerwerte be counted just like text, which is not convertible into figures. Do you want to include all cells, which contain anything, it stands for the function ANZAHL2 available. These include all cells, which are not empty. Cells with empty text is not empty.

The AVERAGE aritmetische provides the means of defined figures. Blank fields are not upošteva, fields with 0 on the other hand, already, even if they do not appear.

The function ABUNDANCE is in a class division over a range of numbers. For example, the data in Figure 3.2 / 8 in five categories, with a clef.
It can use this function automatically creates a frequency distribution of the individual notes, which now has been a rather cumbersome combination of database and multi-operation could be achieved.

The MODALWERT delivers the most value of a data series. With SCHIEFE the skewness of the distribution. The curvature of the distribution compared with a normal distribution is determined by the Kurtosis describe what the function KURT Excel offers.

To those Populations know sizes for a given number of group to be able to quickly determine, there is the command in Excel "analysis functions" In the pull-down menu "Tools". Using this feature allows for a range of cells as comfortable histograms, moving average, rank and quartile, and the drawing of samples carried out.



3.2.4.4. Logische functions

The spreadsheet can no defined processes, as it is not procedurally is built. However, many situations in which, according to a different value, a cell one, or a different value. It is not possible with functions, depending on one condition a value in one or another cell Submitted. But it is quite possible, in a cell, depending on one condition, different values represent. This objective serves the function if:
The truth-value can be used either directly in a cell, then to be referred, or it is the result of a comparison operation.
It often happens that several conditions linked. To serve both AND and OR functions.
The OR function returns true if at least one condition is TRUE, and the function returns the result TRUE if all conditions contained therein are true. With the result is not reversed.

3.2.4.5. Date functions

With the functions DAY, MONTH, YEAR, HOUR, SECOND MINUTE, and the individual values from the serial number. The integer part represents the date, the decimal time. The WEEKDAY function, which is also the current number is used as an argument, returns a number between 1 and 7
Important: The Mac operating system calculates the date generally from 1.1.1904, while Windows default with the 1.1.1900 begins. One must in the Windows version of Excel is the option date values from 1904 to take the same calculation basis.