Returns the current date and time as a date value. Tests an expression against a list of cases and returns the corresponding value of the first matching case, with an optional default value if nothing else is met. Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero. Returns a number associated with the type of data passed into the function. Returns a substring from the beginning of a specified string.

Returns the difference between two days based on the 360 day year used in some financial interest calculations. Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. Returns the sum of a series of numbers and/or cells. In the second sheet, I have a report from Google Analytics with average page load time by URL. Returns the inverse Fisher transformation of a specified value. In this example I filtered all values contained in the column A (rangeA2:A12) greater than 37. The SPLIT formula is pretty self-explanatory; it allows you … If you copy and paste a formula into a new cell, Google Sheets will automatically change it o reference the right cells; for example, if I enter =A2+B2 in cell C2, then drag the formula down to C3, the formula will become =A3+B3. Returns the product of values selected from a database table-like array or range using a SQL-like query. For example, a given complex number "x+yi" returns "tanh(x+yi).". Determines whether two samples are likely to have come from the same two underlying populations that have the same mean. Equivalent to the `>=` operator.

Returns the month of the year a specific date falls in, in numeric format. Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate. Calculates the slope of the line resulting from linear regression of a dataset.

Google Sheets is a powerful and free tool to manage complex spreadsheets. For example, a given complex number "x+yi" returns "cosh(x+yi).

change the language of Google Sheets functions, Learn more about unsupported functions in Sheets, https://wiki.openoffice.org/w/images/b/b3/0300CS3-CalcGuide.pdf, https://creativecommons.org/licenses/by/2.0/legalcode, https://creativecommons.org/licenses/by/2.0/. Finds the weighted average of a set of values, given the values and the corresponding weights. Returns the two tailed Student distribution for a value x. Equivalent to the `+` operator.

Returns the complementary Gauss error function of a value. It’s one formula, with one calculation, but the results are sorted into multiple rows or columns. Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.
Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset.

Returns the minute component of a specific time, in numeric format.