(New in Excel 2019)Ĭompares a number of supplied values to a supplied test expression and returns a result corresponding to the first value that matches the test expression. Tests a number of supplied conditions and returns a result corresponding to the first condition that evaluates to TRUE. Tests if an expression returns the #N/A error and if so, returns an alternative specified value Otherwise the function returns the value of the supplied expression. Tests if an initial supplied value (or expression) returns an error, and if so, returns a supplied value Otherwise the function returns the initial value. Tests a user-defined condition and returns one result if the condition is TRUE, and another result if the condition is FALSE returns FALSE is the supplied argument is TRUE and returns TRUE if the supplied argument is FALSE) Returns a logical value that is the opposite of a user supplied logical value or expression Returns a logical Exclusive Or of all arguments (New in Excel 2013) Tests a number of user-defined conditions and returns TRUE if ANY of the conditions evaluate to TRUE, or FALSE otherwise Tests a number of user-defined conditions and returns TRUE if ALL of the conditions evaluate to TRUE, or FALSE otherwise Substitutes all occurrences of a search text string, within an original text string, with the supplied replacement textĮxcel Logical Functions Boolean Operator Functions Replaces all or part of a text string with another string (from a user supplied position) Replacing / Substituting Parts of a Text String Tests whether a supplied value is text and if so, returns the supplied text If not, returns an empty text string. Tests if two supplied text strings are exactly the same and if so, returns TRUE Otherwise, returns FALSE.
Returns the position of a supplied character or text string from within a supplied text string (non-case-sensitive) Returns the position of a supplied character or text string from within a supplied text string (case-sensitive) Returns the length of a supplied text string Joins together two or more text strings, separated by a delimiter (New in Excel 2016 (or Excel 2019 for Mac)) Returns a string consisting of a supplied text string, repeated a specified number of times Returns a specified number of characters from the end of a supplied text string Returns a specified number of characters from the middle of a supplied text string Returns a specified number of characters from the start of a supplied text string Joins together two or more text strings (Replaced by Concat function in Excel 2016) Joins together two or more text strings (New in Excel 2016 (or Excel 2019 for Mac) - replaces the Concatenate function) Returns the number (code point) corresponding to the first character of a supplied text string (New in Excel 2013)Ĭutting Up & Piecing Together Text Strings Returns the Unicode character that is referenced by the given numeric value (New in Excel 2013)
#Excel 2016 functions list code
Returns the numeric code for the first character of a supplied string Returns the character that corresponds to a supplied numeric value Rounds a supplied number to a specified number of decimal places, and then converts this into textĬonverts a supplied value into text, using a user-specified formatĬonverts a text string into a numeric valueĬonverts text to a number, in a locale-independent way (New in Excel 2013)Ĭonverting Between Characters & Numeric Codes
#Excel 2016 functions list plus
letters that do not follow another letter are upper case and all other characters are lower case)Ĭonverts all characters in a supplied text string to upper caseĬonverts a number, plus the suffix "Baht" into Thai textĬonverts a supplied number into text, using a currency format Removes duplicate spaces, and spaces at the start and end of a text stringįunctions to Convert Between Upper & Lower CaseĬonverts all characters in a supplied text string to lower caseĬonverts all characters in a supplied text string to proper case (i.e. Removes all non-printable characters from a supplied text string
Excel Built-In Function Categories:Įxcel Text Functions Functions to Remove Extra Characters Each of the function links will take you to a dedicated page, where you will find a description of the function, with examples of use and details of common errors.Īlternatively, if you know the name of the function you are interested in, you may prefer to select from the alphabetical functions list. This page provides a complete Excel Functions list, grouped by category.
These functions are organised into categories (text, logical, math, etc.) to help you to locate the function you need from the Excel menu. Excel provides a large number of built-in functions that can be used to perform specific calculations or to return information about your spreadsheet data.
0 kommentar(er)
