A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|

1 | Type | Name | Description | |||||||||||||||||||||||

2 | Array | ARRAY_CONSTRAIN | ARRAY_CONSTRAIN(input_range, num_rows, num_cols) | Constrains an array result to a specified size. Learn more | ||||||||||||||||||||||

3 | Array | TREND | TREND(known_data_y, [known_data_x], [new_data_x], [b]) | Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values. Learn more | ||||||||||||||||||||||

4 | Array | SUMXMY2 | SUMXMY2(array_x, array_y) | Calculates the sum of the squares of differences of values in two arrays. Learn more | ||||||||||||||||||||||

5 | Array | SUMX2PY2 | SUMX2PY2(array_x, array_y) | Calculates the sum of the sums of the squares of values in two arrays. Learn more | ||||||||||||||||||||||

6 | Array | SUMX2MY2 | SUMX2MY2(array_x, array_y) | Calculates the sum of the differences of the squares of values in two arrays. Learn more | ||||||||||||||||||||||

7 | Array | SUMPRODUCT | SUMPRODUCT(array1, [array2, ...]) | Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges. Learn more | ||||||||||||||||||||||

8 | Array | MMULT | MMULT(matrix1, matrix2) | Calculates the matrix product of two matrices specified as arrays or ranges. Learn more | ||||||||||||||||||||||

9 | Array | MINVERSE | MINVERSE(square_matrix) | Returns the multiplicative inverse of a square matrix specified as an array or range. Learn more | ||||||||||||||||||||||

10 | Array | MDETERM | MDETERM(square_matrix) | Returns the matrix determinant of a square matrix specified as an array or range. Learn more | ||||||||||||||||||||||

11 | Array | LOGEST | LOGEST(known_data_y, [known_data_x], [b], [verbose]) | Given partial data about an exponential growth curve, calculates various parameters about the best fit ideal exponential growth curve. Learn more | ||||||||||||||||||||||

12 | Array | LINEST | LINEST(known_data_y, [known_data_x], [calculate_b], [verbose]) | Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method. Learn more | ||||||||||||||||||||||

13 | Array | GROWTH | GROWTH(known_data_y, [known_data_x], [new_data_x], [b]) | Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values. Learn more | ||||||||||||||||||||||

14 | Array | FREQUENCY | FREQUENCY(data, classes) | Calculates the frequency distribution of a one-column array into specified classes. Learn more | ||||||||||||||||||||||

15 | Array | TRANSPOSE | TRANSPOSE(array_or_range) | Transposes the rows and columns of an array or range of cells. Learn more | ||||||||||||||||||||||

16 | Database | DMIN | DMIN(database, field, criteria) | Returns the minimum value selected from a database table-like array or range using a SQL-like query. Learn more | ||||||||||||||||||||||

17 | Database | DVARP | DVARP(database, field, criteria) | Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query. Learn more | ||||||||||||||||||||||

18 | Database | DSUM | DSUM(database, field, criteria) | Returns the sum of values selected from a database table-like array or range using a SQL-like query. Learn more | ||||||||||||||||||||||

19 | Database | DSTDEVP | DSTDEVP(database, field, criteria) | Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query. Learn more | ||||||||||||||||||||||

20 | Database | DSTDEV | DSTDEV(database, field, criteria) | Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query. Learn more | ||||||||||||||||||||||

21 | Database | DPRODUCT | DPRODUCT(database, field, criteria) | Returns the product of values selected from a database table-like array or range using a SQL-like query. Learn more | ||||||||||||||||||||||

22 | Database | DVAR | DVAR(database, field, criteria) | Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query. Learn more | ||||||||||||||||||||||

23 | Database | DMAX | DMAX(database, field, criteria) | Returns the maximum value selected from a database table-like array or range using a SQL-like query. Learn more | ||||||||||||||||||||||

24 | Database | DGET | DGET(database, field, criteria) | Returns a single value from a database table-like array or range using a SQL-like query. Learn more | ||||||||||||||||||||||

25 | Database | DCOUNTA | DCOUNTA(database, field, criteria) | Counts values, including text, selected from a database table-like array or range using a SQL-like query. Learn more | ||||||||||||||||||||||

26 | Database | DCOUNT | DCOUNT(database, field, criteria) | Counts numeric values selected from a database table-like array or range using a SQL-like query. Learn more | ||||||||||||||||||||||

27 | Database | DAVERAGE | DAVERAGE(database, field, criteria) | Returns the average of a set of values selected from a database table-like array or range using a SQL-like query. Learn more | ||||||||||||||||||||||

28 | Date | DATEVALUE | DATEVALUE(date_string) | Converts a provided date string in a known format to a date value. Learn more | ||||||||||||||||||||||

29 | Date | DAY | DAY(date) | Returns the day of the month that a specific date falls on, in numeric format. Learn more | ||||||||||||||||||||||

30 | Date | DAYS | DAYS(end_date, start_date) | Returns the number of days between two dates. | ||||||||||||||||||||||

31 | Date | DAYS360 | DAYS360(start_date, end_date, [method]) | Returns the difference between two days based on the 360 day year used in some financial interest calculations. Learn more | ||||||||||||||||||||||

32 | Date | EDATE | EDATE(start_date, months) | Returns a date a specified number of months before or after another date. Learn more | ||||||||||||||||||||||

33 | Date | EOMONTH | EOMONTH(start_date, months) | Returns a date representing the last day of a month which falls a specified number of months before or after another date. Learn more | ||||||||||||||||||||||

34 | Date | HOUR | HOUR(time) | Returns the hour component of a specific time, in numeric format. Learn more | ||||||||||||||||||||||

35 | Date | ISOWEEKNUM | ISOWEEKNUM(date) | Returns the number of the ISO week of the year where the provided date falls. Learn more | ||||||||||||||||||||||

36 | Date | MINUTE | MINUTE(time) | Returns the minute component of a specific time, in numeric format. Learn more | ||||||||||||||||||||||

37 | Date | MONTH | MONTH(date) | Returns the month of the year a specific date falls in, in numeric format. Learn more | ||||||||||||||||||||||

38 | Date | NETWORKDAYS | NETWORKDAYS(start_date, end_date, [holidays]) | Returns the number of net working days between two provided days. Learn more | ||||||||||||||||||||||

39 | Date | NETWORKDAYS.INTL | NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) | Returns the number of net working days between two provided days excluding specified weekend days and holidays. Learn more | ||||||||||||||||||||||

40 | Date | NOW | NOW() | Returns the current date and time as a date value. Learn more | ||||||||||||||||||||||

41 | Date | SECOND | SECOND(time) | Returns the second component of a specific time, in numeric format. Learn more | ||||||||||||||||||||||

42 | Date | TIME | TIME(hour, minute, second) | Converts a provided hour, minute, and second into a time. Learn more | ||||||||||||||||||||||

43 | Date | TIMEVALUE | TIMEVALUE(time_string) | Returns the fraction of a 24-hour day the time represents. Learn more | ||||||||||||||||||||||

44 | Date | TODAY | TODAY() | Returns the current date as a date value. Learn more | ||||||||||||||||||||||

45 | Date | WEEKDAY | WEEKDAY(date, [type]) | Returns a number representing the day of the week of the date provided. Learn more | ||||||||||||||||||||||

46 | Date | WEEKNUM | WEEKNUM(date, [type]) | Returns a number representing the week of the year where the provided date falls. Learn more | ||||||||||||||||||||||

47 | Date | WORKDAY | WORKDAY(start_date, num_days, [holidays]) | Calculates the end date after a specified number of working days. Learn more | ||||||||||||||||||||||

48 | Date | WORKDAY.INTL | WORKDAY.INTL(start_date, num_days, [weekend], [holidays]) | Calculates the date after a specified number of workdays excluding specified weekend days and holidays. Learn more | ||||||||||||||||||||||

49 | Date | YEAR | YEAR(date) | Returns the year specified by a given date. Learn more | ||||||||||||||||||||||

50 | Date | YEARFRAC | YEARFRAC(start_date, end_date, [day_count_convention]) | Returns the number of years, including fractional years, between two dates using a specified day count convention. Learn more | ||||||||||||||||||||||

51 | Date | DATE | DATE(year, month, day) | Converts a provided year, month, and day into a date. Learn more | ||||||||||||||||||||||

52 | Date | DATEDIF | DATEDIF(start_date, end_date, unit) | Calculates the number of days, months, or years between two dates. Learn more | ||||||||||||||||||||||

53 | Engineering | OCT2BIN | OCT2BIN(signed_octal_number, [significant_digits]) | Converts a signed octal number to signed binary format. Learn more | ||||||||||||||||||||||

54 | Engineering | IMSUB | IMSUB(first_number, second_number) | Returns the difference between two complex numbers. Learn more | ||||||||||||||||||||||

55 | Engineering | IMREAL | IMREAL(complex_number) | Returns the real coefficient of a complex number. Learn more | ||||||||||||||||||||||

56 | Engineering | IMPRODUCT | IMPRODUCT(factor1, [factor2, ...]) | Returns the result of multiplying a series of complex numbers together. Learn more | ||||||||||||||||||||||

57 | Engineering | IMDIV | IMDIV(dividend, divisor) | Returns one complex number divided by another. Learn more | ||||||||||||||||||||||

58 | Engineering | IMCONJUGATE | IMCONJUGATE(number) | Returns the complex conjugate of a number. Learn more | ||||||||||||||||||||||

59 | Engineering | IMAGINARY | IMAGINARY(complex_number) | Returns the imaginary coefficient of a complex number. Learn more | ||||||||||||||||||||||

60 | Engineering | IMABS | IMABS(number) | Returns absolute value of a complex number. Learn more | ||||||||||||||||||||||

61 | Engineering | HEX2OCT | HEX2OCT(signed_hexadecimal_number, significant_digits) | Converts a signed hexadecimal number to signed octal format. Learn more | ||||||||||||||||||||||

62 | Engineering | HEX2DEC | HEX2DEC(signed_hexadecimal_number) | Converts a signed hexadecimal number to decimal format. Learn more | ||||||||||||||||||||||

63 | Engineering | HEX2BIN | HEX2BIN(signed_hexadecimal_number, [significant_digits]) | Converts a signed hexadecimal number to signed binary format. Learn more | ||||||||||||||||||||||

64 | Engineering | GESTEP | GESTEP(value, [step]) | Returns 1 if the rate is strictly greater than or equal to the provided step value or 0 otherwise. If no step value is provided then the default value of 0 will be used. | ||||||||||||||||||||||

65 | Engineering | ERF | ERF(z1, [z2]) | Returns the result of the Gauss error function. | ||||||||||||||||||||||

66 | Engineering | DELTA | DELTA(number1, [number2]) | Compare two numeric values, returning 1 if they're equal. Learn more | ||||||||||||||||||||||

67 | Engineering | DEC2OCT | DEC2OCT(decimal_number, [significant_digits]) | Converts a decimal number to signed octal format. Learn more | ||||||||||||||||||||||

68 | Engineering | DEC2HEX | DEC2HEX(decimal_number, [significant_digits]) | Converts a decimal number to signed hexadecimal format. Learn more | ||||||||||||||||||||||

69 | Engineering | DEC2BIN | DEC2BIN(decimal_number, [significant_digits]) | Converts a decimal number to signed binary format. Learn more | ||||||||||||||||||||||

70 | Engineering | COMPLEX | COMPLEX(real_part, imaginary_part, [suffix]) | Creates a complex number given real and imaginary coefficients. Learn more | ||||||||||||||||||||||

71 | Engineering | BITXOR | BITXOR(value1, value2) | Bitwise boolean XOR (exclusive or) of two numbers. | ||||||||||||||||||||||

72 | Engineering | BITRSHIFT | BITRSHIFT(value, shift_amount) | Shifts the bits of the input a certain number of places to the right. | ||||||||||||||||||||||

73 | Engineering | BITOR | BITOR(value1, value2) | Bitwise boolean OR of two numbers. | ||||||||||||||||||||||

74 | Engineering | BITLSHIFT | BITLSHIFT(value, shift_amount) | Shifts the bits of the input a certain number of places to the left. | ||||||||||||||||||||||

75 | Engineering | BITAND | BITAND(value1, value2) | Bitwise boolean AND of two numbers. | ||||||||||||||||||||||

76 | Engineering | BIN2OCT | BIN2OCT(signed_binary_number, [significant_digits]) | Converts a signed binary number to signed octal format. Learn more | ||||||||||||||||||||||

77 | Engineering | OCT2DEC | OCT2DEC(signed_octal_number) | Converts a signed octal number to decimal format. Learn more | ||||||||||||||||||||||

78 | Engineering | BIN2HEX | BIN2HEX(signed_binary_number, [significant_digits]) | Converts a signed binary number to signed hexadecimal format. Learn more | ||||||||||||||||||||||

79 | Engineering | BIN2DEC | BIN2DEC(signed_binary_number) | Converts a signed binary number to decimal format. Learn more | ||||||||||||||||||||||

80 | Engineering | IMSUM | IMSUM(value1, [value2, ...]) | Returns the sum of a series of complex numbers. Learn more | ||||||||||||||||||||||

81 | Engineering | OCT2HEX | OCT2HEX(signed_octal_number, [significant_digits]) | Converts a signed octal number to signed hexadecimal format. Learn more | ||||||||||||||||||||||

82 | Filter | FILTER | FILTER(range, condition1, [condition2]) | Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions. Learn more | ||||||||||||||||||||||

83 | Filter | SORT | SORT(range, sort_column, is_ascending, [sort_column2], [is_ascending2]) | Sorts the rows of a given array or range by the values in one or more columns. Learn more | ||||||||||||||||||||||

84 | Filter | SORTN | SORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...) | Returns the first n items in a data set after performing a sort. Learn more | ||||||||||||||||||||||

85 | Filter | UNIQUE | UNIQUE(range) | Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range. Learn more | ||||||||||||||||||||||

86 | Financial | ISPMT | ISPMT(rate, period, number_of_periods, present_value) | Interest payment. Calculates the interest paid at a particular period of an investment. | ||||||||||||||||||||||

87 | Financial | PMT | PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning]) | Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more | ||||||||||||||||||||||

88 | Financial | PPMT | PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning]) | Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate. Learn more | ||||||||||||||||||||||

89 | Financial | PRICE | PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention]) | Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. Learn more | ||||||||||||||||||||||

90 | Financial | PRICEDISC | PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention]) | Calculates the price of a discount (non-interest-bearing) security, based on expected yield. Learn more | ||||||||||||||||||||||

91 | Financial | PRICEMAT | PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention]) | Calculates the price of a security paying interest at maturity, based on expected yield. Learn more | ||||||||||||||||||||||

92 | Financial | PV | PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning]) | Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more | ||||||||||||||||||||||

93 | Financial | RATE | RATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess]) | Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate. Learn more | ||||||||||||||||||||||

94 | Financial | RECEIVED | RECEIVED(settlement, maturity, investment, discount, [day_count_convention]) | Calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date. Learn more | ||||||||||||||||||||||

95 | Financial | SLN | SLN(cost, salvage, life) | Calculates the depreciation of an asset for one period using the straight-line method. Learn more | ||||||||||||||||||||||

96 | Financial | SYD | SYD(cost, salvage, life, period) | Calculates the depreciation of an asset for a specified period using the sum of years digits method. Learn more | ||||||||||||||||||||||

97 | Financial | TBILLEQ | TBILLEQ(settlement, maturity, discount) | Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate. Learn more | ||||||||||||||||||||||

98 | Financial | TBILLPRICE | TBILLPRICE(settlement, maturity, discount) | Calculates the price of a US Treasury Bill based on discount rate. Learn more | ||||||||||||||||||||||

99 | Financial | TBILLYIELD | TBILLYIELD(settlement, maturity, price) | Calculates the yield of a US Treasury Bill based on price. Learn more | ||||||||||||||||||||||

100 | Financial | VDB | VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch]) | Returns the depreciation of an asset for a particular period (or partial period). |

Loading...

Main menu