首页 | 官方网站   微博 | 高级检索  
     

IF函数在工资核算中的应用
引用本文:单娟.IF函数在工资核算中的应用[J].宁德师专学报(自然科学版),2012,24(1):51-53.
作者姓名:单娟
作者单位:宁德师范学院数学系,福建宁德352100.
摘    要:工资核算作为企业财会部门日常工作中最经常的项目,不仅花费财会人员大量的时间精力,而且极易出错.如果能将Excel中的IF函数灵活应用到工资核算中,将使实际工作中繁琐、复杂的运算变得相当简便,达到事半功倍的效果.以ABC公司的工资计算为例介绍IF函数的应用.

关 键 词:IF函数  工资核算  筛选功能

Application of IF function in the payroll accounting
SHAN Juan.Application of IF function in the payroll accounting[J].Journal of Ningde Teachers College(Natural Science),2012,24(1):51-53.
Authors:SHAN Juan
Affiliation:SHAN Juan(Department of Mathematics,Ningde Normal University,Ningde,Fujian 352100,China)
Abstract:Payroll accounting,the most frequently used project in the daily work of the corporate accounting department,not only takes the accountants a lot of time and efforts,but is error-prone.If the IF function in Excel is flexibly applied in the payroll accounting,it will make the tedious and complex calculation become quite simple and achieve a multiplier effect.In this paper,the wage calculation of the ABC Company is taken as an example to introduce the application of the IF function.
Keywords:IF function  payroll accounting  filtering
本文献已被 维普 万方数据 等数据库收录!
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司    京ICP备09084417号-23

京公网安备 11010802026262号