1. é»è¾å¤æ
é»è¾å¤ææç¨çå½æ°ä¸å¤ï¼IFãANDãORä¸ä¸ªå°±è¶³ä»¥åºä»æ¥å¸¸å·¥ä½äºã
IFå½æ°å¯ä»¥ç¨æ¥è½¬æ¢å¼ï¼å¦å°1å0转æ¢ä¸ºOKåNGï¼
=IF(A1=1,"OK","NG")ä¸ANDåORç»å使ç¨å¯ä»¥å¤æå¤ä¸ªæ¡ä»¶ï¼å¦å¤ææ¯å¦æ¯å¨æ«ï¼
=IF(OR(WEEKDAY(A1)=0, WEEKDAY(A1)=6),"å¨æ«","å·¥ä½æ¥")2. ç»è®¡æ°éçCOUNTãCOUNTAãCOUNTIF
COUNTåCOUNTAç»è®¡å¯¹è±¡ä¸åï¼COUNTAç»è®¡ææé空åå
æ ¼çæ°éï¼å
æ¬åºéçåå
æ ¼ï¼ï¼ COUNTä»
ç»è®¡çèµ·æ¥åæ°åçåå
æ ¼ã
COUNTIFåå¯ä»¥æ·»å æç´¢æ¡ä»¶ï¼è¿ä¸ªç¹æ§å¯ä»¥ç¨æ¥åç»è®¡ãå¦
=COUNTIF(F:F,"OK") ç»è®¡Fåä¸OKç个æ°
=COUNTIF(F:F,"NG") ç»è®¡Fåä¸NGç个æ°3. æ±åçSUM
è¿ä¸ªå½æ°ç®åå¾ä¸è½åç®åäºï¼
=SUM(A10:A254) 对A10ï½A254çèå´æ±å没äºãå«çExcelå½æ°æç¾ä¸åï¼å¸¸ç¨çå°±è¿å 个ãå
å
¶éåå ä¸å
¶ä»å 个信æ¯å½æ°ï¼å¦æ±æ¥æçDATEãYEARãMONTHãDAYãNOWãWEEKDAYï¼æ°å¼è®¡ç®çFLOORãINTãMODãROUNDï¼å符串æä½çCHARãLEFTãRIGHTãMIDï¼å
·ä½ä½¿ç¨æ¹æ³åè§å¸®å©ï¼ï¼å ä¹å¯ä»¥åºä»å
¨é¨çæ¥å¸¸åºç¨ã
ä¸é¢ä¸¾å 个ä¾åæ¥è¯´æè¿äºå½æ°çåºç¨ã
1. æµè¯ç¨ä¾ãä¸è¬æµè¯ç¨ä¾çè¡¨æ ¼ä¼æ¯è¿æ ·ï¼
A B C D E F
1 ç¼å· ç±»å« æµè¯å
容 确认å
容 ç»æ æµè¯æ¶é´
2 1 çé¢ åå»æ°å»ºæé® å»ºç«æ°ææ¡£ OK 8/27
3 2 çé¢ åå»ä¿åæé® ä¿åææ¡£ OK 8/27
3 2 çé¢ åå»å¦åä¸ºé® æå¼ä¿å对è¯æ¡ NG 8/27
é£ä¹ç»è®¡OKåNGç个æ°å°±åå«ç¨
=COUNTIF(E:E,"OK") ç»è®¡OK个æ°
=COUNTIF(E:E,"NG") ç»è®¡NG个æ°å¦ææµè¯ç¨ä¾åæ好å 个工ä½è¡¨ï¼é£ä¹å¯ä»¥å¨æåé¢å ä¸ä¸ªç»è®¡ç¨çå·¥ä½è¡¨ï¼å¹¶ç¨SUMæ±åºææç¨ä¾çç¶åµã
2. æ¥åãè¿ä¸ªæ¥åæ¯ç¨å¨é¡¹ç®è¿åº¦ç®¡çä¸çï¼æ ¼å¼ç±»ä¼¼äºä¸é¢è¿ç§æ¨ªåçæ¥åã
8æ
1 2 3 4 5 6 7 8 9 10 11
ä¸ å äº å
æ¥ ä¸ äº ä¸ å äº å
å¯æ以ä¸æ ¼å¼è¾å
¥ï¼
A B C D E F G
1 8/1 =A1+1 =B1+1 ... ... ... ...
2 =MONTH(A1) =IF(MONTH(B1)=MONTH(A1), "",MONTH(B1) ... ... ... ... ...
3 =DAY(A1) =DAY(B1) ... ... ... ... ...
4 =MID("æ¥ä¸äºä¸åäºå
",WEEKDAY(A1),1) ... ... ... ... ... ...
ç¶åéèæ第ä¸è¡å³å¯ã
温馨提示:答案为网友推荐,仅供参考