Financial

İNDİS

Başvurudan veya diziden bir değer seçmek için, bir dizin kullanır

Math and Trigonometry

ABS

Returns the absolute value of a number.

Financial

ACCRINT

Returns the accrued interest for a security that pays periodic interest.

Financial

ACCRINTM

Returns the accrued interest for a security that pays interest at maturity.

Math and Trigonometry

ACOSH

Returns the inverse hyperbolic cosine of a number.

Math and Trigonometry

ACOTH

Returns the inverse hyperbolic arccotangent of a number.

Lookup and Reference

ADDRESS

Returns a reference as text to a single cell in a worksheet.

Financial

AMORDEGRC

Returns the depreciation for each accounting period by using a depreciation coefficient.

Financial

AMORLINC

Returns the depreciation for each accounting period.

Logical

AND

Returns TRUE if all of its arguments are TRUE.

Lookup and Reference

AREAS

Returns the number of areas in a reference.

Text

ARRAYTOTEXT

Belirtilen herhangi bir aralıktan bir dizi metin değeri döndürür. Metin değerlerini değiştirmeden iletir ve metin olmaya...

Text

ASC

Changes full-width characters to half-width characters.

Math and Trigonometry

ASINH

Returns the inverse hyperbolic sine of a number.

Math and Trigonometry

ATAN2

Returns the arctangent from x- and y-coordinates.

Math and Trigonometry

ATANH

Returns the inverse hyperbolic tangent of a number.

Statistical

AVEDEV

Returns the average of the absolute deviations of data points from their mean.

Statistical

AVERAGE

Calculates the arithmetic mean of its arguments.

Statistical

AVERAGEA

Calculates the average of its arguments, including numbers, text, and logical values.

Statistical

AVERAGEIF

Calculates the average of cells that meet a given criteria.

Financial

AVERAGEIFS

Calculates the average of cells that meet multiple criteria.

Text

BAHTTEXT

Returns the arccosecant of a number.

Math and Trigonometry

BASE

Returns the inverse hyperbolic arccosecant of a number.

Engineering

BESSELI

Rounds a number up, to the nearest integer or to the nearest multiple of significance.