以å½æ°sumï¼leftï¼textï¼vlookupï¼ifæ¥ä¸¾ä¾è¯´æï¼
1.sumæ±åå½æ°
ç¨æ³=sum(æ±ååºå)ï¼æ¯å¦sum(A1:B2,D1:E2)ï¼å°±æ¯æ±A1:B2åD1:E2两个åºåå
æææ°å¼çåï¼
2.leftä»å·¦è¾¹åæå®é¿åº¦å符串å½æ°
ç¨æ³=left(å符串ææå¨åå
æ ¼ï¼é¿åº¦ï¼ï¼æ¯å¦left(A1,1)ï¼å°±æ¯ä»A1ç左边åä¸ä½ææ¬ï¼ä¾å¦A1ä¸æ¯âABCâï¼åæ¤å
¬å¼ç»æ为A
3.textææ¬æ ¼å¼å½æ°
ç¨æ³=text(å符串æåå
æ ¼ï¼ææ¬æ ¼å¼)ï¼æ¯å¦text(A1,"000")ï¼å°±æ¯è®©A1å
çå
容åæâ000âè¿ç§æ ¼å¼ï¼å¦A1ä¸ä¸º1ï¼åå为001
4.vlookupæ¥æ¾å¹¶è¿åæå®å¼å½æ°
ç¨æ³=vlookupï¼æ¥æ¾å¼ï¼æ¥æ¾åºåï¼è¿åæ¥æ¾åºååæ°ï¼å¹é
æ¹å¼ï¼ï¼æ¯å¦Vlookupï¼A1,C:Dï¼2,0ï¼ï¼å°±æ¯ä»Cåä¸æ¥æ¾ä¸A1ä¸å
¨ç¸åçæ°å¼ï¼å¹¶è¿å对åºçDåçå¼
5.ifæ¡ä»¶å½æ°
ç¨æ³=if(æ¡ä»¶ï¼æ¡ä»¶æç«è¿åå¼ï¼æ¡ä»¶ä¸æç«è¿åå¼ï¼ï¼åå
¥if(A1>B1,1,0)ï¼å°±æ¯å¦æA1çå¼å¤§äºB1çå¼ï¼åç»æ为1ï¼å¦åç»æ为0
温馨提示:答案为网友推荐,仅供参考