The Analysis of Several Commonly Used Excel Function in Accounting Practice

Abstract

The Excel spreadsheet built-in a lot of function, is widely applied in the actual work area, such as accounting, financial management. This paper introduces two commonly used Excel function: the IF function and VLOOKUP function, and use these functions to solve the actual financial problems. Using the If function, for example, the seven layers of nested solved the problem of calculation of individual income tax. By using VLOOKUP function in Excel data list, we find the target data and references.