What is GCD function in Excel? GCD function is one of the Math and Trig functions in Microsoft Excel that returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder. Syntax of GCD function GCD(number1, [number2], …) The GCD …
What is LCM function in Excel? LCM function is one of the Math and Trig functions in Microsoft Excel that returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all integer arguments number1, number2, and so on. Use LCM to add fractions with …
What is LN function in Excel? LN function is one of the Math and Trig functions in Microsoft Excel that returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904). Syntax of LN function LN(number) The LN function syntax has the following arguments: Number: The positive real number for which …
What is LOG function in Excel? LOG function is one of the Math and Trig functions in Microsoft Excel that returns the logarithm of a number to the base you specify. Syntax of LOG function LOG(number, [base]) The LOG function syntax has the following arguments: Number: The positive real number for which you want the logarithm. …
What is MDETERM function in Excel? MDETERM function is one of the Math and Trig functions in Microsoft Excel that returns the matrix determinant of an array. Syntax of MDETERM function MDETERM(array) The MDETERM function syntax has the following arguments: Array: A numeric array with an equal number of rows and columns. MDETERM formula explanation Array …
In addition to formulas, another way to conduct mathematical computations in Excel is through functions. Statistical functions apply a mathematical process to a group of cells in a worksheet. This chapter gives an overview of some very useful statistical functions like: AVERAGE function, AVERAGEIF function, MEDIAN function, SUMIF function, MIN function, MODE function, STEDV function, LARGE function, SMALL function. Average To calculate the average of a …
The VLOOKUP function is one of the most popular functions in Excel. This chapter contains many easy to follow VLOOKUP examples for Exact Match, Approximate Match, Right Lookup, First Match, Case-insensitive, Multiple Criteria, #N/A error and Multiple Lookup Tables. Exact Match Most of the time you are looking for an exact match when you use the VLOOKUP function in Excel. …
The OFFSET function in Excel returns a cell or range of cells that is a specified number of rows and columns from a cell or range of cells. OFFSET function Syntax; OFFSET(reference, rows, cols, [height], [width]) 1. The OFFSET function below returns the cell that is 3 rows below and 2 columns to the right of cell A2. The …
What is CLEAN function in Excel? CLEAN function is one of TEXT functions in Microsoft Excel that removes all nonprintable characters from text. Use CLEAN on text imported from other applications that contains characters that may not print with your operating system. For example, you can use CLEAN to remove some low-level computer code that …
What is CHAR function in Excel? CHAR function is one of TEXT functions in Microsoft Excel that returns the character specified by a number. Use CHAR to translate code page numbers you might get from files on other types of computers into characters. Operating environment Character set Macintosh Macintosh character set Windows ANSI The ANSI …
What are SEARCH, SEARCHB functions in Excel? SEARCH, SEARCHB functions are TEXT functions in Microsoft Excel that locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string. Syntax of SEARCH, SEARCHB functions SEARCH(find_text,within_text,[start_num]) SEARCHB(find_text,within_text,[start_num]) The SEARCH and …
What are RIGHT, RIGHTB functions in Excel? RIGHT, RIGHTB functions are TEXT functions in Microsoft Excel RIGHT returns the last character or characters in a text string, based on the number of characters you specify. While, RIGHTB returns the last character or characters in a text string, based on the number of bytes you specify. Important: …
What are REPLACE, REPLACEB functions in Excel? REPLACE, REPLACEB functions TEXT functions in Microsoft Exce. REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string. While REPLACEB replaces part of a text string, based on the number of bytes you specify, with a different text …
What is PROPER function in Excel? PROPER function is one of TEXT functions in Microsoft Excel that capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters. Syntax of PROPER function PROPER(text) The PROPER function syntax has …
What is NUMBERVALUE function in Excel? NUMBERVALUE function is one of TEXT functions in Microsoft Excel that converts text to a number, in a locale-independent way. Syntax of NUMBERVALUE function NUMBERVALUE(Text, [Decimal_separator], [Group_separator ]) The NUMBERVALUE function syntax has the following arguments. Text: The text to convert to a number. Decimal_separator(Optional): The character used to separate …
What are MID, MIDB functions in Excel? MID, MIDB functions are TEXT functions in Microsoft Excel. MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify. While, MIDB returns a specific number of characters from a text string, starting at the …
What is LOWER function in Excel? LOWER function is one of TEXT functions in Microsoft Excel that converts all uppercase letters in a text string to lowercase. Syntax of LOWER function LOWER(text) The LOWER function syntax has the following arguments: Text: The text you want to convert to lowercase. LOWER does not change characters in text …
What are LEFT, LEFTB functions in Excel? LEFT, LEFTB functions are TEXT functions in Microsoft Excel. LEFT returns the first character or characters in a text string, based on the number of characters you specify. While, LEFTB returns the first character or characters in a text string, based on the number of bytes you specify. Important: …
What is FIXED function in Excel? FIXED function is one of TEXT functions in Microsoft Excel that rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text. Syntax of FIXED function FIXED(number, [decimals], [no_commas]) The FIXED function syntax has the …
What are LEN, LENB functions in Excel? LEN, LENB functions are TEXT functions in Microsoft Excel. LEN returns the number of characters in a text string.While, LENB returns the number of bytes used to represent the characters in a text string. Important: These functions may not be available in all languages. LENB counts 2 bytes per …
What is REPT function in Excel? REPT function is one of TEXT functions in Microsoft Excel that repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string. Syntax of REPT function REPT(text, number_times) The REPT function syntax has the following arguments: Text Required. The text …
What is UNICODE function in Excel? UNICODE function is one of TEXT functions in Microsoft Office Excel that returns the number (code point) corresponding to the first character of the text. Syntax of UNICODE function UNICODE(text) The UNICODE function syntax has the following arguments. Text: Text is the character for which you want the Unicode value. …
What is UNICHAR function in Excel? UNICHAR function on is one of TEXT functions in Microsoft Office Excel that returns the Unicode character that is referenced by the given numeric value. Syntax of UNICHAR function UNICHAR(number) The UNICHAR function syntax has the following arguments. Number Required. Number is the Unicode number that represents the character. UNICHAR …
What is TRIM function in Excel? TRIM function is one of TEXT functions in Microsoft Office Excel that removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing. Important: The TRIM function was designed to trim the 7-bit ASCII …
What is TEXTJOIN function in Excel? TEXTJOIN function is one of TEXT functions in Microsoft Office Excel that TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the …
What is TEXT function in Excel? TEXT function is one of Microsoft Office Excel TEXT functions that lets you change the way a number appears by applying formatting to it with format codes. It’s useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text …
What is T function in Excel? T function is one of TEXT functions in Microsoft Office Excel that returns the text referred to by value. Syntax of T function T(value) The T function syntax has the following arguments: Value: The value you want to test. T formula explanation If value is or refers to text, T returns …
What is SUBSTITUTE function in Excel? SUBSTITUTE function is one of TEXT functions in Microsoft Excel that substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a …
What is UPPER function in Excel? UPPER function is one of TEXT functions in Microsoft Office Excel that converts text to uppercase. Syntax of UPPER function UPPER(text) The UPPER function syntax has the following arguments: Text: The text you want converted to uppercase. Text can be a reference or text string. Example of UPPER function Steps to follow: …
What is PHONETIC function in Excel? PHONETIC function is one of TEXT functions in Microsoft Office Excel that extracts the phonetic (furigana) characters from a text string. Syntax of PHONETIC function PHONETIC(reference) The PHONETIC function syntax has the following arguments: Reference: Text string or a reference to a single cell or a range of cells that contain …
What is ACCRINT function in Excel? ACCRINT function is one of the Financial functions in Microsoft Excel that returns the accrued interest for a security that pays periodic interest. Syntax of ACCRINT function ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method]) The ACCRINT function syntax has the following arguments: Issue: The security’s issue date. First_interest: The …
What is COUPDAYBS function in Excel? COUPDAYBS function is one of the Financial functions in Microsoft Excel that returns the number of days from the beginning of a coupon period until its settlement date. Syntax of COUPDAYBS function COUPDAYBS(settlement, maturity, frequency, [basis]) The COUPDAYBS function syntax has the following arguments: Settlement: The security’s settlement date. The …
What is AMORLINC function in Excel? AMORLINC function is one of the Financial functions in Microsoft Excel that returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account. Syntax of AMORLINC …
What is AMORDEGRC function in Excel? AMORDEGRC function is one of the Financial functions in Microsoft Excel that returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account. The function …
What is ACCRINTM function in Excel? ACCRINTM function is one of the Financial functions in Microsoft Excel that returns the accrued interest for a security that pays interest at maturity. Syntax of ACCRINTM function ACCRINTM(issue, settlement, rate, par, [basis]) The ACCRINTM function syntax has the following arguments: Issue: The security’s issue date. Settlement: The security’s maturity …
What is YIELDMAT function in Excel? YIELDMAT function is one of the Financial functions in Microsoft Excel that returns the annual yield of a security that pays interest at maturity. Syntax of YIELDMAT function YIELDMAT(settlement, maturity, issue, rate, pr, [basis]) The YIELDMAT function syntax has the following arguments: Settlement: The security’s settlement date. The security settlement date …
What is CUMIPMT function in Excel? CUMIPMT function is one of the Financial functions in Microsoft Excel that returns the cumulative interest paid on a loan between start_period and end_period. Syntax of CUMIPMT function CUMIPMT(rate, nper, pv, start_period, end_period, type) The CUMIPMT function syntax has the following arguments: Rate: The interest rate. Nper: The total number …
What is COUPPCD function in Excel? COUPPCD function is one of the Financial functions in Microsoft Excel that returns a number that represents the previous coupon date before the settlement date. Syntax of COUPPCD function COUPPCD(settlement, maturity, frequency, [basis]) The COUPPCD function syntax has the following arguments: Settlement: The security’s settlement date. The security settlement date …
What is COUPNUM function in Excel? COUPNUM function is one of the Financial functions in Microsoft Excel that returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon. Syntax of COUPNUM function COUPNUM(settlement, maturity, frequency, [basis]) The COUPNUM function syntax has the following arguments: Settlement: The …
What is COUPNCD function in Excel? COUPNCD function is one of the Financial functions in Microsoft Excel that returns a number that represents the next coupon date after the settlement date. Syntax of COUPNCD function COUPNCD(settlement, maturity, frequency, [basis]) The COUPNCD function syntax has the following arguments: Settlement: The security’s settlement date. The security settlement date …