Excel 2013 functions know early

The Office 2013 Client preview (Customer Preview) has been officially released and new versions of Office have changed in many ways. With more than 50 new functions added to Excel 2013, starting today, I'll introduce some of these new functions and attach an application example. The name of this series is called "Excel 2013 function early know", hope through this series can let your ancestors one step as soon as possible to master new features of Excel function, in use more handy.

1,formulatext

Type: Query Reference class

Function: Returns the formula text within a cell

Syntax: FormulaText (Reference)

Application:

Assuming that the formula is used in cell C4, the following formula can be entered in another cell to return the formula contents of the C4 cell in this cell, and the data type is a text string:

=formulatext (C4)

This feature is required in the existing version (EXCEL2003~2010) for macro-table functions Get.cell to be implemented, and can now be completely replaced with this function (no longer need to define name and enable macros). In some scenarios where formulas are explained and demonstrated, this function can be used to show the specific formulas used in a cell.

2,isformula

Type: Information class

Function: Determine if the contents of a cell are a formula

Syntax: Isformula (Reference)

Application:

Use the following formula to determine whether the contents of a cell in C4 is a formula, to return true, or to return false:

=isformula (C4)

In an existing version (Excel 2003~2010), you can use the information class function to determine whether the content in a cell is text (istext/isnontext), numeric (isnumber), error value (ISERR/ISERROR/ISNA), References (ISREF), null values (ISBLANK), logical values (islogical), Parity (iseven/isodd), and so on. Now this new function can determine whether the cell content is a formula, and once again expands the information class function family.

3,webservice

Type: Network class

Function: Get data directly through network connection

Syntax: WEBSERVICE (URL)

Application: The following formula can be directly obtained through the link address of the current United States dollar exchange rate (RMB 100 for U.S. dollars)

=webservice ("http://api.liqwei.com/currency/?") exchange=cny| Usd&count=100 ")

This function should be one of the most attractive functions in version 2013, a function that can derive countless magical functions. The Web class function is one of the new function categories in the Excel2013 version, which currently contains only 3 functions. It can be directly used to get the data through the web link, without programming without enabling macros, as long as the network can.

In an existing version (Excel 2003~2010), you can use Excel to import data from a Web page or get information programmatically from a Web server, and now it's a major improvement to get web data directly from a function formula. For the foreseeable future, web apps like Google Translations, weather queries, stock exchange rates and so on can easily be used directly in Excel to achieve data landing (for example, the web link used in the above example is an API for getting real-time rates).