Excel中函数的嵌套应用

The Nested Function Application of Excel

Excel是office办公系统中的一款数据处理的常用软件,它不仅能够方便地处理表格和进行图形分析,而且更强大的功能体现在对数据的自动处理和计算方面,而函数是实现数据处理的一种方式.很多繁杂的数据处理都可以通过函数来实现.Excel包含有11类函数,只要按函数的结构进行参数设置就能准确地计算出结果,文章通过if函数的嵌套应用和if与vlookup函数的结合应用说明了函数的具体使用过程.

Excel is a data processing software of Office. It can facilitate processing tabular and graphical analysis. More powerful features are embodied in the automatic data processing and calculation. Function is one way of data processing. Many complicated data processing can be realized through the function. Excel contains 11 kinds of functions. As long as the function of the structure was set, it can accurately calculate the results. This article is about its precise use through the application of if nested function and the combination of if and vlookup functions.