A | B | C | D | E | F | G | |
---|---|---|---|---|---|---|---|
1 | Category | E- Excel / G-Google | Function | Usage | Excel Description | Google Description | http://tiny.cc/sseg |
2 | Array | EG | TRANSPOSE | TRANSPOSE(array_or_range) | Returns the transpose of an array | Transposes the rows and columns of an array or range of cells. | |
3 | Date & Time | G | DATEDIF | DATEDIF(start_date, end_date, unit) | Calculates the number of days, months, or years between two dates. | ||
4 | Date & Time | EG | DATEVALUE | DATEVALUE(date_string) | Converts a date in the form of text to a serial number | Converts a provided date string in a known format to a date value. | |
5 | Date & Time | EG | DAY | DAY(date) | Converts a serial number to a day of the month | Returns the day of the month that a specific date falls on, in numeric format. | |
6 | Date & Time | EG | DAYS360 | DAYS360(start_date, end_date, method) | Calculates the number of days between two dates based on a 360-day year | Returns the difference between two days based on the 360 day year used in some financial interest calculations. | |
7 | Date & Time | EG | EDATE | EDATE(start_date) | Returns the serial number of the date that is the indicated number of months before or after the start date | Returns a date a specified number of months before or after another date. | |
8 | Date & Time | EG | NETWORKDAYS | NETWORKDAYS(start_date, end_date, holidays) | Returns the number of whole workdays between two dates | Returns the number of net working days between two provided days. | |
9 | Date & Time | EG | NOW | NOW() | Returns the serial number of the current date and time | Returns the current date and time as a date value. | |
10 | Date & Time | EG | TIME | TIME(hour, minute, second) | Returns the serial number of a particular time | Converts a provided hour, minute, and second into a time. | |
11 | Date & Time | EG | TIMEVALUE | TIMEVALUE(time_string) | Converts a time in the form of text to a serial number | Returns the fraction of a 24-hour day the time represents. Only available in the new Google Sheets. | |
12 | Date & Time | EG | TODAY | TODAY() | Returns the serial number of today's date | Returns the current date as a date value. | 4/15/2023 |
13 | Date & Time | EG | WEEKDAY | WEEKDAY(date, type) | Converts a serial number to a day of the week | Returns a number representing the day of the week of the date provided. | |
14 | Date & Time | EG | WEEKNUM | WEEKNUM(date, [type]) | Converts a serial number to a number representing where the week falls numerically with a year | Returns a number representing the week of the year where the provided date falls. Only available in the new Google Sheets. | |
15 | Date & Time | EG | WORKDAY | WORKDAY(start_date, num_days, holidays) | Returns the serial number of the date before or after a specified number of workdays | Calculates the number of working days from a specified start date. | |
16 | Date & Time | EG | YEAR | YEAR(date) | Converts a serial number to a year | Returns the year specified by a given date. | |
17 | Date & Time | EG | YEARFRAC | YEARFRAC(start_date, end_date, day_count_convention) | Returns the year fraction representing the number of whole days between start_date and end_date | Returns the number of years, including fractional years, between two dates using a specified day count convention. | |
18 | Filter | G | FILTER | FILTER(range, condition1, condition2) | Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions. | ||
19 | Filter | G | 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. | ||
20 | Filter | G | 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. | ||
21 | G | ARRAYFORMULA | ARRAYFORMULA(array_formula) | Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays. | |||
22 | G | IMAGE | IMAGE(url, mode) | Inserts an image into a cell. | |||
23 | G | IMPORTHTML | IMPORTHTML(url, query, index) | Imports data from a table or list within an HTML page. | |||
24 | G | IMPORTRANGE | IMPORTRANGE(spreadsheet_key, range_string) | Imports a range of cells from a specified spreadsheet. | |||
25 | G | IMPORTXML | IMPORTXML(url, xpath_query) | Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds. | |||
26 | G | QUERY | QUERY(data, query, headers) | Runs a Google Visualization API Query Language query across data. | |||
27 | G | SPARKLINE | SPARKLINE(data, options) | Creates a miniature chart contained within a single cell. | |||
28 | Information | EG | CELL | CELL(info_type, reference) | Returns information about the formatting, location, or contents of a cell | Returns the requested information about the specified cell. Only available in the new Google Sheets. | |
29 | Information | EG | ERROR.TYPE | ERROR.TYPE(reference) | Returns a number corresponding to an error type | Returns a number corresponding to the error value in a different cell. | |
30 | Information | EG | ISBLANK | ISBLANK(value) | Returns TRUE if the value is blank | Checks whether the referenced cell is empty. | |
31 | Information | G | ISEMAIL | ISEMAIL(value) | Checks whether a value is a valid email address. Only available in the new Google Sheets. | ||
32 | Information | EG | ISERR | ISERR(value) | Returns TRUE if the value is any error value except #N/A | Checks whether a value is an error other than `#N/A`. | |
33 | Information | EG | ISERROR | ISERROR(value) | Returns TRUE if the value is any error value | Checks whether a value is an error. | |
34 | Information | EG | ISLOGICAL | ISLOGICAL(value) | Returns TRUE if the value is a logical value | Checks whether a value is `TRUE` or `FALSE`. | |
35 | Information | EG | ISNA | ISNA(value) | Returns TRUE if the value is the #N/A error value | Checks whether a value is the error `#N/A`. | |
36 | Information | EG | ISNONTEXT | ISNONTEXT(value) | Returns TRUE if the value is not text | Checks whether a value is non-textual. | |
37 | Information | EG | ISNUMBER | ISNUMBER(value) | Returns TRUE if the value is a number | Checks whether a value is a number. | |
38 | Information | EG | ISREF | ISREF(value) | Returns TRUE if the value is a reference | Checks whether a value is a valid cell reference. | |
39 | Information | EG | ISTEXT | ISTEXT(value) | Returns TRUE if the value is text | Checks whether a value is text. | |
40 | Information | G | ISURL | ISURL(value) | Checks whether a value is a valid URL. Only available in the new Google Sheets. | ||
41 | Information | EG | TYPE | TYPE(value) | Returns a number indicating the data type of a value | Returns a number associated with the type of data passed into the function. Only available in the new Google Sheets. | |
42 | Logical | EG | ADDRESS | ADDRESS(row, column, absolute_relative_mode, use_a1_notation, sheet) | Returns a reference as text to a single cell in a worksheet | Returns a cell reference as a string. | |
43 | Logical | EG | AND | AND(logical_expression1, logical_expression2) | Returns TRUE if all of its arguments are TRUE | Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false. | |
44 | Logical | EG | IF | IF(logical_expression, value_if_true, value_if_false) | Specifies a logical test to perform | Returns one value if a logical expression is `TRUE` and another if it is `FALSE`. | |
45 | Logical | EG | IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula | Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent. | |
46 | Logical | EG | NOT | NOT(logical_expression) | Reverses the logic of its argument | Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`. | |
47 | Logical | EG | OR | OR(logical_expression1, logical_expression2) | Returns TRUE if any argument is TRUE | Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false. | |
48 | Lookup & Reference | EG | CHOOSE | CHOOSE(index, choice1, choice2) | Chooses a value from a list of values | Returns an element from a list of choices based on index. | |
49 | Lookup & Reference | EG | COLUMN | COLUMN(cell_reference) | Returns the column number of a reference | Returns the column number of a specified cell, with `A=1`. | |
50 | Lookup & Reference | EG | COLUMNS | COLUMNS(range) | Returns the number of columns in a reference | Returns the number of columns in a specified array or range. | |
51 | Lookup & Reference | EG | HLOOKUP | HLOOKUP(search_key, range, index, is_sorted) | Looks in the top row of an array and returns the value of the indicated cell | Horizontal lookup. Searches across the first row of a range for a key and returns the value of a specified cell in the column found. | |
52 | Lookup & Reference | EG | HYPERLINK | HYPERLINK(url, link_label) | Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet | Creates a hyperlink inside a cell. | |
53 | Lookup & Reference | EG | INDEX | INDEX(reference, row, column) | Uses an index to choose a value from a reference or array | Returns the content of a cell, specified by row and column offset. | |
54 | Lookup & Reference | EG | LOOKUP | LOOKUP(search_key, search_range|search_result_array, [result_range]) | Looks up values in a vector or array | Looks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column. Only available in the new Google Sheets. | |
55 | Lookup & Reference | EG | MATCH | MATCH(search_key, range, search_type) | Looks up values in a reference or array | Returns the relative position of an item in a range that matches a specified value. | |
56 | Lookup & Reference | EG | OFFSET | OFFSET(cell_reference, offset_rows, offset_columns, height, width) | Returns a reference offset from a given reference | Returns a range reference shifted a specified number of rows and columns from a starting cell reference. | |
57 | Lookup & Reference | EG | ROW | ROW(cell_reference) | Returns the row number of a reference | Returns the row number of a specified cell. | |
58 | Lookup & Reference | EG | ROWS | ROWS(range) | Returns the number of rows in a reference | Returns the number of rows in a specified array or range. | |
59 | Lookup & Reference | EG | VLOOKUP | VLOOKUP(search_key, range, index, is_sorted) | Looks in the first column of an array and moves across the row to return the value of a cell | Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found. | |
60 | Math/ Statistical | EG | COUNTBLANK | COUNTBLANK(range) | Counts the number of blank cells within a range | Returns the number of empty cells in a given range. | |
61 | Math/ Statistical | EG | COUNTIF | COUNTIF(range, criterion) | Counts the number of cells within a range that meet the given criteria | Returns a conditional count across a range. | |
62 | Math/ Statistical | EG | COUNTIFS | COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...]) | Counts the number of cells within a range that meet multiple criteria | Returns the count of a range depending on multiple criteria. Only available in thenew Google Sheets. | |
63 | Math/ Statistical | G | COUNTUNIQUE | COUNTUNIQUE(value1, value2) | Counts the number of unique values in a list of specified values and ranges. | ||
64 | Math/ Statistical | EG | EVEN | EVEN(value) | Rounds a number up to the nearest even integer | Rounds a number up to the nearest even integer. | |
65 | Math/ Statistical | EG | FLOOR | FLOOR(value, factor) | Rounds a number down, toward zero | Rounds a number down to the nearest integer multiple of specified significance. | |
66 | Math/ Statistical | EG | ISEVEN | ISEVEN(value) | Returns TRUE if the number is even | Checks whether the provided value is even. | |
67 | Math/ Statistical | EG | ISODD | ISODD(value) | Returns TRUE if the number is odd | Checks whether the provided value is odd. | |
68 | Math/ Statistical | EG | ODD | ODD(value) | Rounds a number up to the nearest odd integer | Rounds a number up to the nearest odd integer. | |
69 | Math/ Statistical | EG | PRODUCT | PRODUCT(factor1, factor2) | Multiplies its arguments | Returns the result of multiplying a series of numbers together. | |
70 | Math/ Statistical | EG | RAND | RAND() | Returns a random number between 0 and 1 | Returns a random number between 0 inclusive and 1 exclusive. | |
71 | Math/ Statistical | EG | RANDBETWEEN | RANDBETWEEN(low, high) | Returns a random number between the numbers you specify | Returns a uniformly random integer between two values, inclusive. | |
72 | Math/ Statistical | EG | ROUND | ROUND(value, places) | Rounds a number to a specified number of digits | Rounds a number to a certain number of decimal places according to standard rules. | |
73 | Math/ Statistical | EG | ROUNDDOWN | ROUNDDOWN(value, places) | Rounds a number down, toward zero | Rounds a number to a certain number of decimal places, always rounding down to the next valid increment. | |
74 | Math/ Statistical | EG | ROUNDUP | ROUNDUP(value, places) | Rounds a number up, away from zero | Rounds a number to a certain number of decimal places, always rounding up to the next valid increment. | |
75 | Math/ Statistical | EG | SUBTOTAL | SUBTOTAL(function_code, range1, range2) | Returns a subtotal in a list or database | Returns a subtotal for a vertical range of cells using a specified aggregation function. | |
76 | Math/ Statistical | EG | SUM | SUM(value1, value2) | Adds its arguments | Returns the sum of a series of numbers and/or cells. | |
77 | Math/ Statistical | EG | SUMIF | SUMIF(range, criterion, sum_range) | Adds the cells specified by a given criteria | Returns a conditional sum across a range. | |
78 | Math/ Statistical | EG | SUMIFS | SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...]) | Adds the cells in a range that meet multiple criteria | Returns the sum of a range depending on multiple criteria. Only available in thenew Google Sheets. | |
79 | Parser | G | SPLIT | SPLIT(text, delimiter, split_by_each) | TEXT TO COLUMNS | Divides text around a specified character or string, and puts each fragment into a separate cell in the row. (TEXT TO COLUMNS, PARSE) | |
80 | Parser | G | CONVERT | CONVERT(value, start_unit, end_unit) | Converts a numeric value to a different unit of measure. | ||
81 | Parser | G | TO_DATE | TO_DATE(value) | Converts a provided number to a date. | ||
82 | Parser | G | TO_DOLLARS | TO_DOLLARS(value) | Converts a provided number to a dollar value. | ||
83 | Parser | G | TO_PERCENT | TO_PERCENT(value) | Converts a provided number to a percentage. | ||
84 | Parser | G | TO_PURE_NUMBER | TO_PURE_NUMBER(value) | Converts a provided date/time, percentage, currency or other formatted numeric value to a pure number without formatting. | ||
85 | Paste Special | EG | PS- Values Only | If imported or copied data ends up as text in an Excel worksheet it can create problems if that data is used in calculations involving functions. Paste special offers a quick and easy way to correct the problem by converting the text back to number data. | Pastes only the text contained in the original range of cells. | ||
86 | Paste Special | G | Ctrl+Shift+V | Match destination formatting: Formats the pasted data to match the formatting already existing in the new location. | Paste Text Without Formatting in Google Chrome. (Will mimic all ready in place text style.) | ||
87 | Paste Special | E | PS- Values and Number Formats | Values and Number Formatting: Formatting is preserved only for numeric values, including dates. In addition, only formula results (see "Values Only") are pasted. Text formatting is removed. | |||
88 | Paste Special | EG | PS- Formats Only | Formatting only: Pastes only the formatting, leaving all values and formulas out of the pasted range. | This option is identical to using the paint format tool -- it only copies cell formatting, and won't disrupt any existing text or formulas. | ||
89 | Paste Special | G | PS- Conditional Formatting Only | This option only applies conditional formatting rules to a range of cells. | |||
90 | Paste Special | EG | PS- Formulas Only | Match destination formatting: Formats the pasted data to match the formatting already existing in the new location. | Pastes the formulas contained in a copied range of cells, not the resulting calculations of the formulas. | ||
91 | Paste Special | E | PS- Formulas and number formats | Keep source formatting: Preserves all original formatting of the pasted selection. Preserves all formulas as well. | |||
92 | Paste Special | E | PS- Column widths | Keep source column widths: Preserves the column widths as well as all formulas and formatting. | |||
93 | Paste Special | EG | PS- Validation Only | Pastes data validation rules for the copied cells to the paste area. | Pastes a data validation rule over a range of cells without disrupting any existing formatting, formulas or text. | ||
94 | Paste Special | EG | PS- All Except Borders | Pastes all of these options without any cell borders that have been added. | |||
95 | Paste Special | EG | PS- Tanspose | To transpose data, in spreadsheet talk, means to switch the layout of data located in rows to columns and data in columns to rows. | This option allows you to paste a rotated version of the copied cells. For example, if you copy a column of cells and use paste transpose, it will paste them into a row, and vice versa. | ||
96 | Paste Special | E | PS- Skip Blanks | Avoids replacing values in your paste area when blank cells occur in the copy area when you select this check box. | |||
97 | Paste Link | E | Paste Link | Lets you create a link between areas of data that will update when the source data changes. This linking can also be done for multiple copies of the same Excel chart located in different files. Link data located on separate worksheets or in separate Excel files using Paste Link. When the source file changes, the destination file will update as well. | |||
98 | Statistical | EG | AVERAGE | AVERAGE(value1, value2) | Returns the average of its arguments | Returns the numerical average value in a dataset, ignoring text. | |
99 | Statistical | EG | AVERAGEIF | AVERAGEIF(criteria_range, criterion, [average_range]) | Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria | Returns the average of a range depending on criteria. Only available in the new Google Sheets | |
100 | Statistical | EG | AVERAGEIFS | AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...]) | Returns the average (arithmetic mean) of all cells that meet multiple criteria. | Returns the average of a range depending on multiple criteria. Only available in thenew Google Sheets |