刍议Excel函数在高校人事工资批量调整中的应用

:2007-05-13:(1979-),,,:Excel(,516007):,,,Excel,:Excel:TP39:A:1671-5934(2007)03-0080-04ExcelOffice,,Excel,,,,ExcelExcel,,,,,,Excel,1Excel(1)Excel,,VLOOKUP,(2)IF,IF,100,IF:=IF(=,=100,=0)(3)SUM,SUM,[1](4),Excel,,,,;,(5)VLOOKUP,,27320076()JOURNALOFHUIZHOUUNIVERSITYVol127No13Jun120072Excel,,,,,Excel,(1),,Excel,:(1)12311A422B533C644D755E866F977G1088H1199I121010J(2)Excel,()[2],()vlookup22361F41010J533C611A755E877G988H1099I1122B1244D(3)ExcelvlookupExcelvlookup,Vlookup,183:Excel:vlookup(lookupvalue,tablearray,colindexnum,rangelookup),:vlookup(,,,TrueFalse)[3]Lookupvalue,Lookupvalue,E3Tablearray,()3123a1a2a3b1b2b3c1c2c3d1d2d3e1e2e3f1f2f3g1g2g3h1h2h3i1j2j3j1j2j3ColindexnumtablearrayColindexnum1,ta2blearray;Colindexnum2,tablearray,1,Colindexnum2;2,Colindexnum3(4),4F2Fx=VLOOKUP(E2,I3;L12,2,FALSE)ABCDEF11266Fb131010Jg1433Cd1511Ah1655Ef1777Gj1888Ha1999Ic11022Bj11144Dj128()200727Colindexnum1,VLOOKUP#VALUE!;Colindexnumtablearray,vlookup#REF!Rangelookup,vlookupTRUE,,,,lookupvalue;rangevalueFALSE,vlookup,#NPARangelookupFALSE,11h1,2h2,3h3(5)5ABCDEFGH1123266Fb1b2b331010Jg1g2g3433Cd1d2d3511Ah1h2h3655Ef1f2f3777Gj1j2j3888Ha1a2a3999Ic1c2c31022Bi1i2i31144Di1i2i33ExcelEx2cel,,,:[1].Excel[J].,2006,(12):55-56[2].[J].,2006,(25):281[3],.EXCEL[J].,2006,(16):25-26:DiscussionontheApplicationofExcelFunctiontoBatchesofSalaryAdjustmentinUniversitiesHEHai2xia(PersonelDepartment,HuizhouUniversity,Huizhou516015,GuangdongChina)Abstract:Thesalary,whichisapartofpersonnelmanagementincolleges,involvespersonnelofdifferentpostsandclassifications.Whenlargequantitiesofpersonnelpspostsandclassificationsmodify,thesalaryofthemneedstobeadjustedinalargeamount.InthispaperIdiscussedmygainsindepthofcomprehensioncombiningmyownworkingpracticeontheapplicationofExcelfunctioninbatch2esofsalaryadjustmentincolleges.Keywords:Excelworksheet,salary,adjustmentinbatches,application383:Excel