Logical functions (reference)
Click one of the links in the following list to see detailed help about the function.
Function | Description |
Returns TRUE if all of its arguments are TRUE | |
Returns the logical value FALSE | |
Specifies a logical test to perform | |
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula | |
Reverses the logic of its argument | |
Returns TRUE if any argument is TRUE | |
Returns the logical value TRUE |
Information functions (reference)
Click one of the links in the following list to see detailed help about the function.
Function | Description |
Returns information about the formatting, location, or contents of a cell | |
Returns a number corresponding to an error type | |
Returns information about the current operating environment | |
Returns TRUE if the value is blank | |
Returns TRUE if the value is any error value except #N/A | |
Returns TRUE if the value is any error value | |
Returns TRUE if the number is even | |
Returns TRUE if the value is a logical value | |
Returns TRUE if the value is the #N/A error value | |
Returns TRUE if the value is not text | |
Returns TRUE if the value is a number | |
Returns TRUE if the number is odd | |
Returns TRUE if the value is a reference | |
Returns TRUE if the value is text | |
Returns a value converted to a number | |
Returns the error value #N/A | |
Returns a number indicating the data type of a value |
Cube functions (reference)
Click one of the links in the following list to see detailed help about the function.
Function | Description |
Returns a key performance indicator (KPI) property and displays the KPI name in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, that is used to monitor an organization's performance. | |
Returns a member or tuple from the cube. Use to validate that the member or tuple exists in the cube. | |
Returns the value of a member property from the cube. Use to validate that a member name exists within the cube and to return the specified property for this member. | |
Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or the top 10 students. | |
Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel. | |
Returns the number of items in a set. | |
Returns an aggregated value from the cube. |
Text functions (reference)
Click one of the links in the following list to see detailed help about the function.
Function | Description |
Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters | |
Converts a number to text, using the ß (baht) currency format | |
Returns the character specified by the code number | |
Removes all nonprintable characters from text | |
Returns a numeric code for the first character in a text string | |
Joins several text items into one text item | |
Converts a number to text, using the $ (dollar) currency format | |
Checks to see if two text values are identical | |
Finds one text value within another (case-sensitive) | |
Formats a number as text with a fixed number of decimals | |
Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters | |
Returns the leftmost characters from a text value | |
Returns the number of characters in a text string | |
Converts text to lowercase | |
Returns a specific number of characters from a text string starting at the position you specify | |
Extracts the phonetic (furigana) characters from a text string | |
Capitalizes the first letter in each word of a text value | |
Replaces characters within text | |
Repeats text a given number of times | |
Returns the rightmost characters from a text value | |
Finds one text value within another (not case-sensitive) | |
Substitutes new text for old text in a text string | |
Converts its arguments to text | |
Formats a number and converts it to text | |
Removes spaces from text | |
Converts text to uppercase | |
Converts a text argument to a number |
Date and time functions (reference)
Click one of the links in the following list to see detailed help about the function.
Function | Description |
Returns the serial number of a particular date | |
Converts a date in the form of text to a serial number | |
Converts a serial number to a day of the month | |
Calculates the number of days between two dates based on a 360-day year | |
Returns the serial number of the date that is the indicated number of months before or after the start date | |
Returns the serial number of the last day of the month before or after a specified number of months | |
Converts a serial number to an hour | |
Converts a serial number to a minute | |
Converts a serial number to a month | |
Returns the number of whole workdays between two dates | |
Returns the serial number of the current date and time | |
Converts a serial number to a second | |
Returns the serial number of a particular time | |
Converts a time in the form of text to a serial number | |
Returns the serial number of today's date | |
Converts a serial number to a day of the week | |
Converts a serial number to a number representing where the week falls numerically with a year | |
Returns the serial number of the date before or after a specified number of workdays | |
Converts a serial number to a year | |
Returns the year fraction representing the number of whole days between start_date and end_date |
Lookup and reference functions (reference)
Click one of the links in the following list to see detailed help about the function.
Function | Description |
Returns a reference as text to a single cell in a worksheet | |
Returns the number of areas in a reference | |
Chooses a value from a list of values | |
Returns the column number of a reference | |
Returns the number of columns in a reference | |
Looks in the top row of an array and returns the value of the indicated cell | |
Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet | |
Uses an index to choose a value from a reference or array | |
Returns a reference indicated by a text value | |
Looks up values in a vector or array | |
Looks up values in a reference or array | |
Returns a reference offset from a given reference | |
Returns the row number of a reference | |
Returns the number of rows in a reference | |
Returns the transpose of an array | |
Looks in the first column of an array and moves across the row to return the value of a cell |
No comments:
Post a Comment