Excel functions--date, Substitute, REPLACE, ISERROR, IFERROR

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.