1. DATE
The date function returns a sequential sequence number that represents a specific date. For example, the formula
=date (2008,7,8)
Returns 2008-7-8 or 39637, depending on the format of the cell, but empty cells are calculated and the default date format is assumed.
DATE can also operate on numbers with only the latter two digits of the year, such as =date (90,1,1):
This will solve the problem of how to extract birthdays from 15-bit IDs.
2, substitute
Replace Old_text with new_text in a text string. If you need to replace the specified text in a text string, use the function substitute;
If you need to replace any text at the specified position in a text string, use the function Replace.
3. REPLACE
Replace uses a different text string and replaces some of the text in a text string based on the number of characters you specify.
REPLACEB uses a different text string and replaces some of the text in a text string based on the number of bytes specified.
4, ISERROR
The value is any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL!), returns TRUE
function |
returns TRUE if it is: |
isblank |
The value is a blank cell. |
iserr |
The value is any error value (minus #N/a). |
iserror |
value is any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL!). |
islogical |
The value is a logical value. |
isna |
The value is the error value #N/A (the value does not exist). |
isnontext |
Value is any item that is not text (note that this function returns TRUE when the value is an empty cell). |
isnumber |
The value is a number. |
isref |
The value is a reference. |
Istext |
The value is text. |
If you want to implement what you do when the value is wrong, you need to mate with the IF function.
Such as:
5, IFERROR
But this is not the time to do so, Excel takes into account the needs of everyone, with its own iferror function:
IFERROR (value, Value_if_error)
The IFERROR function syntax has the following parameters parameter: A value that provides information for an action, event, method, property, function, or procedure. ):
- value is required. Check if there are any wrong arguments.
- Value_if_error required. The formula evaluates to an error when the value to return. The calculated error types are: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? Or #NULL!.
Excel functions--date, Substitute, REPLACE, ISERROR, IFERROR