首页 > 教育

excel函数计算品种百分比

更新时间2019-01-23 11:21:53

分类标准ABC分类结果类别金额百分比类别金额百分比品种百分比A类80%A79.36% B类15%B15.36% C类5%C5.28% 合计  存货名称存货金额(元)金额百分比累计百分比类别标志SXZJ36027333017.6651%17.6651%ATZ22026531017.1467%34.8118%AYXZB2801362208.8038%43.6156%ATYXC937606.0596%49.6752%ADWJC192664004.2914%53.9665%ATLZJ220605503.9133%57.8798%ABHHJ150591903.8254%61.7052%ATDMC435202.8127%64.5179%AQZDJ290399002.5787%67.0966%ABLPJ128372602.4081%69.5047%AQZKB160357102.3079%71.8126%ATLMJ130354982.2942%74.1068%AJSLL003297101.9201%76.0269%ASDMC125277801.7954%77.8223%AGSKJ920237701.5362%79.3585%ACSTJ910167301.0812%80.4398%BWZJJ002156501.0114%81.4512%BKQSM810145300.9391%82.3903%BDDHJ180131800.8518%83.2421%BBZDK230129200.8350%84.0771%BHBGS180129100.8344%84.9114%btSWN210125900.8137%85.7251%BDWGT280117000.7562%86.4813%BQTBH310113000.7303%87.2116%BLQLJ810110000.7109%87.9225%BKQGZ125108500.7012%88.6237%BZHJC350102800.6644%89.2881%BHZGZ12190900.5875%89.8756%BCDJZ00289000.5752%90.4508%BDYZZ16086200.5571%91.0079%BLDSY18683100.5371%91.5450%BHZYK12069400.4485%91.9935%BYXGD62065900.4259%92.4194%btKQM13065300.4220%92.8414%BTWMC98061000.3942%93.2357%BTWJM91059880.3870%93.6227%BFXMC18059300.3833%94.0059%BHBGS35058700.3794%94.3853%BTKYJ65051900.3354%94.7207%BKGZP18046000.2973%95.0180%CHTKJ28044000.2844%95.3024%CTYNT42100.2721%95.5745%CKQYS11039200.2533%95.8278%CZDGP62038500.2488%96.0766%CMGAQ12537900.2449%96.3216%CTZWJL2037500.2424%96.5639%CTGQC62036500.2359%96.7998%CTSNM12534600.2236%97.0234%CLYZJ16532900.2126%97.2361%CQZDS00132700.2113%97.4474%CZPEJ41031900.2062%97.6536%CHTJX12530800.1991%97.8526%CKQTJ12527000.1745%98.0271%CYXCZ62026500.1713%98.1984%CTL01025400.1642%98.3626%CQBSK23025300.1635%98.5261%CLFJX81024800.1603%98.6864%CJTZH16022600.1461%98.8324%CTZMJ83020900.1351%98.9675%CKQTJ18518100.1170%99.0845%CQZZH62018000.1163%99.2008%CDCSY12912800.0827%99.2835%CBSXC82011100.0717%99.3553%CHJJQ13511000.0711%99.4264%CQZXT1309600.0620%99.4884%CTCWDL3209200.0595%99.5479%CYSJX5209000.0582%99.6060%CHLFJ1608600.0556%99.6616%CFTLM0066400.0414%99.7030%CTNMC1605460.0353%99.7383%CTZNY8505000.0323%99.7706%CYXJC1355000.0323%99.8029%CTLYM4750.0307%99.8336%CFTLM2014500.0291%99.8627%CTNYM4503930.0254%99.8881%CTGWM3070.0198%99.9079%CZXJX1553000.0194%99.9273%CCXMC9102600.0168%99.9441%CTXRM1202300.0149%99.9590%CCJZD1831800.0116%99.9706%CCXMC8101800.0116%99.9822%CFLZH1011200.0078%99.9900%CTBZD520950.0061%99.9961%CBSGC005400.0026%99.9987%CMTCZ150200.0013%100.0000%C合计1547292100.0000%  

你把表格截图发,这样没人能看明白excel函数计算品种百分比

相关标签:excel

上一篇:同一瓶水,小乐喝了三分之一,小亮喝了二分之一。()得多

下一篇:以谁谁谁真不简单为题的作文,求点拨