Funkcji matematyczne

[ ] indicates optional parameters

ACOS(liczba)
ACOSH(liczba)
ASIN(liczba)
ASINH(liczba)
ATAN(liczba)
ATAN2(x_liczba, y_liczba)
ATANH(liczba)
COS(liczba)
COSH(liczba)
EXP(liczba)
GCD(liczba1, [liczba2, ...])
ILOCZYN(liczba1, [liczba2, ...])
KOMBINACJE(liczba, liczba_wybrana)
LCM(liczba1, [liczba2, ...])
LICZ.JEŻELI(zakres, kryteria)
LICZBA.CAŁK(liczba, [liczba_cyfr])
LN(liczba)
LOG(liczba, [podstawa])
LOG10(liczba)
LOS()
MACIERZ.ILOCZYN(tablica1, tablica2)
MACIERZ.ODW(tablica)
MOD(liczba, dzielnik)
MODUŁ.LICZBY(liczba)
MROUND(liczba, multiple)
MULTINOMIAL(liczba1, [liczba2, ...])
PI()
PIERWIASTEK(liczba)
POTĘGA(liczba, potęga)
QUOTIENT(numerator, denominator)
RADIANY(kąt)
RANDBETWEEN(smallest, largest)
RZYMSKIE(liczba, [forma])
SERIESSUM(x, n, m, coefficients)
SILNIA(liczba)
SIN(liczba)
SINH(liczba)
SQRTPI(liczba)
STOPNIE(kąt)
SUMA(liczba1, [liczba2, ...])
SUMA.ILOCZYNÓW(tablica1, [tablica2, ...])
SUMA.JEŻELI(zakres, kryteria, [suma_zakres])
SUMA.KWADRATÓW(liczba1, [liczba2, ...])
SUMA.X2.M.Y2(tablica_x, tablica_y)
SUMA.X2.P.Y2(tablica_x, tablica_y)
SUMA.XMY.2(tablica_x, tablica_y)
SUMY.POŚREDNIE(funkcja_nr, adres1, [adres2, ...])
TAN(liczba)
TANH(liczba)
WYZNACZNIK.MACIERZY(tablica)
ZAOKR(liczba, liczba_cyfr)
ZAOKR.DO.CAŁK(liczba)
ZAOKR.DO.NPARZ(liczba)
ZAOKR.DO.PARZ(liczba)
ZAOKR.DÓŁ(liczba, [liczba_cyfr])
ZAOKR.GÓRA(liczba, [liczba_cyfr])
ZAOKR.W.DÓŁ(liczba, istotność)
ZAOKR.W.GÓRĘ(liczba, istotność)
ZNAK.LICZBY(liczba)


Funkcji matematyczne

ACOS(liczba)

Returns the angle in radians corresponding to the arccosine of a number.

liczbaThe number for which you want the arccosine.


ACOSH(liczba)

Returns the angle in radians corresponding to the inverse hyperbolic cosine of a number.

liczbaThe number for which you want the inverse hyperbolic cosine.


ASIN(liczba)

Returns the angle in radians corresponding to the arcsine of a number.

liczbaThe number for which you want the arcsine.


ASINH(liczba)

Returns the angle in radians corresponding to the inverse hyperbolic sine of a number.

liczbaThe number for which you want the inverse hyperbolic sine.


ATAN(liczba)

Returns the angle in radians corresponding to the arctangent of a number.

liczbaThe number for which you want the arctangent.


ATAN2(x_liczba, y_liczba)

Returns the angle in radians corresponding to a pair of co-ordinates.

x_liczbaThe x co-ordinate for which you want the angle.
y_liczbaThe y co-ordinate for which you want the angle.


ATANH(liczba)

Returns the angle in radians corresponding to the inverse hyperbolic tangent of a number.

liczbaThe number for which you want the inverse hyperbolic tangent.


COS(liczba)

Returns the cosine of an angle.

liczbaThe angle for which you want the cosine. It must be specified in radians.


COSH(liczba)

Returns the hyperbolic cosine of an angle.

liczbaThe angle for which you want the hyperbolic cosine. It must be specified in radians.


EXP(liczba)

Returns the e raised to the power number.

liczbaThe power to which you want to raise e.


GCD(liczba1, [liczba2, ...])

Returns the greatest common divisor of a set of numbers.

liczba1, ...The numbers of which you want the greatest common divisor.


ILOCZYN(liczba1, [liczba2, ...])

Returns the product of a list of numbers.

liczba1, ...The numbers that you want to multiply together.


KOMBINACJE(liczba, liczba_wybrana)

Returns the number of combinations in which a number of items can be chosen from a total number.

liczbaThe total number of items.
liczba_wybranaThe number of items chosen.


LCM(liczba1, [liczba2, ...])

Returns the lowest common multiple of a set of numbers.

liczba1, ...The numbers of which you want the lowest common multiple.


LICZ.JEŻELI(zakres, kryteria)

Returns the number of cells in a specified range that meet the specified criteria.

zakresA reference to the cells you want to count.
kryteriaA string containing a comparison expression.


LICZBA.CAŁK(liczba, [liczba_cyfr])

Returns a number truncated to the number of decimal places specified.

liczbaThe number that you want truncated.
liczba_cyfrThe number of decimal places to truncate to (may be negative).


LN(liczba)

Returns the natural logarithm of a number.

liczbaThe number for which you want the natural logarithm.


LOG(liczba, [podstawa])

Returns the logarithm of a number in a specified base.

liczbaThe number for which you want the logarithm.
podstawaThe base in which you want the logarithm. If this parameter is omitted it defaults to 10.


LOG10(liczba)

Returns the base 10 logarithm of a number.

liczbaThe number for which you want the base 10 logarithm.


LOS()

Returns a random number between 0 and 1.



MACIERZ.ILOCZYN(tablica1, tablica2)

Returns the product of two matrices.

tablica1An array or reference to cells containing the first matrix.
tablica2An array or reference to cells containing the second matrix.


MACIERZ.ODW(tablica)

Returns the inverse of a matrix.

tablicaAn array or reference to cells containing the matrix.


MOD(liczba, dzielnik)

Returns the remainder of a division.

liczbaThe dividend.
dzielnikThe divisor.


MODUŁ.LICZBY(liczba)

Returns the absolute value of a number.

liczbaThe number for which you want the absolute value.


MROUND(liczba, multiple)

Returns the number rounded to a multiple.

liczbaThe number that you want rounded.
multipleThe multiple to which you want the number rounded.


MULTINOMIAL(liczba1, [liczba2, ...])

Returns the factorial of the sum of the values divided by the product of their factorials.

liczba1, ...The numbers of which you want the multinomial.


PI()

Returns the value of Pi.



PIERWIASTEK(liczba)

Returns the square root of a number.

liczbaThe number of which you want the square root.


POTĘGA(liczba, potęga)

Returns the number raised to the power.

liczbaThe number which you want raised to a power.
potęgaThe power to which you want to raise the number.


QUOTIENT(numerator, denominator)

Returns the integer result of a division.

numeratorThe dividend.
denominatorThe divisor.


RADIANY(kąt)

Converts an angle from degrees to radians.

kątThe angle that you want to convert.


RANDBETWEEN(smallest, largest)

Returns a random integer in the range you specify.

smallestThe lower limit of the range.
largestThe upper limit of the range.


RZYMSKIE(liczba, [forma])

Returns a string representing a number converted to roman numerals.

liczbaThe number that you want to convert.
formaSpecifies the compactness of the representation. The possible values are:
0Classic
1More compact
2More compact
3More compact
4Simplified
PRAWDAClassic
FAŁSZSimplified
If this parameter is omitted it defaults to 0.


SERIESSUM(x, n, m, coefficients)

Returns the value of a polynomial.

xThe number to be raised to a power.
nThe power of the first term in the series.
mThe difference between successive powers in the series.
coefficientsAn array or reference to cells containing the coefficients.


SILNIA(liczba)

Returns the factorial of a number.

liczbaThe number of which you want the factorial.


SIN(liczba)

Returns the sine of an angle.

liczbaThe angle for which you want the sine. It must be specified in radians.


SINH(liczba)

Returns the hyperbolic sine of an angle.

liczbaThe angle for which you want the hyperbolic sine. It must be specified in radians.


SQRTPI(liczba)

Returns the square root of a number after it is multiplied by Pi.

liczbaThe number which you want to multiply by Pi and then take the square root.


STOPNIE(kąt)

Converts an angle from radians to degrees.

kątThe angle that you want to convert.


SUMA(liczba1, [liczba2, ...])

Returns the sum of a list of numbers.

liczba1, ...The numbers that you want to add together.


SUMA.ILOCZYNÓW(tablica1, [tablica2, ...])

Returns the sum of the products of the cells in one or more ranges.

tablica1, ...The ranges of cells where corresponding values are multiplied together and then summed.


SUMA.JEŻELI(zakres, kryteria, [suma_zakres])

Returns the sum of cells in a specified range that meet the specified criteria.

zakresA reference to the cells you want to check.
kryteriaA string containing a comparison expression.
suma_zakresA range containing values to be summed where the values in the first range meet the specified criteria. If this parameter is omitted then the values in the first range are summed.


SUMA.KWADRATÓW(liczba1, [liczba2, ...])

Returns the sum of the squares of the numbers in the list.

liczba1, ...The numbers that are to be squared and then summed.


SUMA.X2.M.Y2(tablica_x, tablica_y)

Returns the sum of the differences of the squares of the numbers in the ranges.

tablica_xThe first range of numbers.
tablica_yThe second range of numbers.


SUMA.X2.P.Y2(tablica_x, tablica_y)

Returns the sum of the sums of the squares of the numbers in the ranges.

tablica_xThe first range of numbers.
tablica_yThe second range of numbers.


SUMA.XMY.2(tablica_x, tablica_y)

Returns the sum of the squares of the differences of the numbers in the ranges.

tablica_xThe first range of numbers.
tablica_yThe second range of numbers.


SUMY.POŚREDNIE(funkcja_nr, adres1, [adres2, ...])

Returns the subtotal of values in one or more ranges, excluding other subtotal figures.

funkcja_nrThe subtotal function that you want. The possible values are:
1ŚREDNIA
2ILE.LICZB
3ILE.NIEPUSTYCH
4MAX
5MIN
6ILOCZYN
7ODCH.STANDARDOWE
8ODCH.STANDARD.POPUL
9SUMA
10WARIANCJA
11WARIANCJA.POPUL
adres1, ...The ranges of cells that you want subtotalled.


TAN(liczba)

Returns the tangent of an angle.

liczbaThe angle for which you want the tangent. It must be specified in radians.


TANH(liczba)

Returns the hyperbolic tangent of an angle.

liczbaThe angle for which you want the hyperbolic tangent. It must be specified in radians.


WYZNACZNIK.MACIERZY(tablica)

Returns the determinant of a matrix.

tablicaAn array or reference to cells containing the matrix.


ZAOKR(liczba, liczba_cyfr)

Returns a number rounded to the number of decimal places specified.

liczbaThe number that you want rounded.
liczba_cyfrThe number of decimal places to round to (may be negative).


ZAOKR.DO.CAŁK(liczba)

Returns the number rounded down to the next integer.

liczbaThe number which you want rounded.


ZAOKR.DO.NPARZ(liczba)

Returns the number rounded up to the next odd number.

liczbaThe number which you want rounded.


ZAOKR.DO.PARZ(liczba)

Returns the number rounded up to the next even number.

liczbaThe number which you want rounded.


ZAOKR.DÓŁ(liczba, [liczba_cyfr])

Returns a number rounded down to the number of decimal places specified.

liczbaThe number that you want rounded.
liczba_cyfrThe number of decimal places to round to (may be negative). If this parameter is omitted it defaults to 0.


ZAOKR.GÓRA(liczba, [liczba_cyfr])

Returns a number rounded up to the number of decimal places specified.

liczbaThe number that you want rounded.
liczba_cyfrThe number of decimal places to round to (may be negative). If this parameter is omitted it defaults to 0.


ZAOKR.W.DÓŁ(liczba, istotność)

Returns the number rounded down (towards zero) to the next multiple of significance.

liczbaThe number which you want rounded.
istotnośćThe units you want to use for rounding.


ZAOKR.W.GÓRĘ(liczba, istotność)

Returns the number rounded up (away from zero) to the next multiple of significance.

liczbaThe number which you want rounded.
istotnośćThe units you want to use for rounding.


ZNAK.LICZBY(liczba)

Returns the sign of a number; 1 for positive, -1 for negative and 0 for zero.

liczbaThe number of which you want the sign.