| Functions | Syntax | Description | Example |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) |
| ACOS | ACOS(number) | Returns the arccosine of a number. | ACOS(0.5) |
| AND | AND(logical1, [logical2], …) | Returns TRUE if all arguments are TRUE. | AND(A1>0, B1<5) |
| CHOOSE | CHOOSE(index_num, value1, [value2], …) | Chooses a value from a list of values. | CHOOSE(2, “Apple”, “Banana”, “Cherry”) |
| COUNT | COUNT(value1, [value2], …) | Counts how many numbers are in the list of arguments. | COUNT(A1:A10) |
| COUNTA | COUNTA(value1, [value2], …) | Counts how many values are in the list of arguments. | COUNTA(A1:A10) |
| COUNTIF | COUNTIF(range, criteria) | Counts the number of cells that meet a criterion. | COUNTIF(A1:A10, “>5”) |
| IFERROR | IFERROR(value, value_if_error) | Returns a value you specify if a formula evaluates to an error. | IFERROR(1/0, “Error”) |
| LEFT | LEFT(text, [num_chars]) | Returns the first character(s) in a text string. | LEFT(“Excel”, 2) |
| RIGHT | RIGHT(text, [num_chars]) | Returns the last character(s) in a text string. | RIGHT(“Excel”, 3) |
| MID | MID(text, start_num, num_chars) | Returns a specific number of characters from a text string. | MID(“Excel”, 2, 3) |
| ROUND | ROUND(number, num_digits) | Rounds a number to a specified number of digits. | ROUND(3.14159, 2) |
| RAND | RAND() | Returns a random number between 0 and 1. | RAND() |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | Returns a random integer between the numbers you specify. | RANDBETWEEN(1, 10) |
| TRIM | TRIM(text) | Removes all spaces from text except for single spaces between words. | TRIM(” Hello World “) |
| PROPER | PROPER(text) | Capitalizes the first letter of each word in a text string. | PROPER(“hello world”) |
| SUBTOTAL | SUBTOTAL(function_num, ref1, [ref2],…) | Returns a subtotal in a list or database. | SUBTOTAL(9, A1:A10) |
| TEXT | TEXT(value, format_text) | Formats a number and converts it to text. | TEXT(1234.567, “#,##0.00”) |
| UNIQUE | UNIQUE(array, [by_col], [exactly_once]) | Returns unique values from a range or array. | UNIQUE(A1:A10) |
| XLOOKUP | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) | Searches a range or array, returns an item corresponding to the first match. | XLOOKUP(101, A2:A10, B2:B10) |
