Examples of nesting of Excel functions

Source: Internet
Author: User

The function is often used in Excel, because we have to count different data, so we need to use the function.

There are two ways to use functions in Excel, that is, to use a single function and nesting to use multiple functions.

The so-called nested use function, refers to the use of multiple functions at the same time, the purpose is to achieve a complex statistical function.

Here, let me introduce you to the use of Excel function nesting, give you a number of examples.

Nested use of one or two functions

A, =isblank (INDIRECT ($C $18))

As the result of the nested function above returns False,indirect ($C $18) first returns the value of the $c$18 cell, because the cell has a value, so the result of ISBLANK (INDIRECT ($C $18) is naturally false, otherwise, true.

B, =text (now (), "yyy") =text (Now (), "MM") =text (Now (), "D") =text (Now (), "dddd") =text (Now (), "hh:mm")

Take a look at the simple nested functions above, which are returned to the text after data such as the day of the month in date function now (). Convert to text using the text function.

Nesting of multiple functions

For example: =index ($I $: $I $8,match ($K $: $K $8,1), $K $ $K $))

The result of the function does not say, only lets you see nested examples of multiple functions

Another example: =address (ROW (), COLUMN (),)

Look at one more: =index ($I $: $I $8,match (MAX ($J $ $J $), $J $ $J))

Finally, let me show you one example:

=if (ISNA (VLOOKUP ("Zhang Yi", i4:k8,2,)), "", VLOOKUP ("Zhang Yi", i4:k8,2,))

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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.