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 Keywords:
Related Article E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China Alibaba Cloud Free Trial

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