以=å·å¼å¤´ã常ç¨å¦ä¸ï¼
ABSï¼æ±åºåæ°çç»å¯¹å¼ã
ãANDï¼âä¸âè¿ç®ï¼è¿åé»è¾å¼ï¼ä»
å½æåæ°çç»æå为é»è¾âçï¼TRUEï¼âæ¶è¿åé»è¾âçï¼TRUEï¼âï¼åä¹è¿åé»è¾âåï¼FALSEï¼âã
ãAVERAGEï¼æ±åºææåæ°çç®æ¯å¹³åå¼ã
ãCOLUMN ï¼æ¾ç¤ºæå¼ç¨åå
æ ¼çåæ å·å¼ã
ãCONCATENATE ï¼å°å¤ä¸ªå符ææ¬æåå
æ ¼ä¸çæ°æ®è¿æ¥å¨ä¸èµ·ï¼æ¾ç¤ºå¨ä¸ä¸ªåå
æ ¼ä¸ã
ãCOUNTIF ï¼ç»è®¡æ个åå
æ ¼åºåä¸ç¬¦åæå®æ¡ä»¶çåå
æ ¼æ°ç®ã
ãDATE ï¼ç»åºæå®æ°å¼çæ¥æã
ãDATEDIFå½æ°ï¼è®¡ç®è¿å两个æ¥æåæ°çå·®å¼ã
ãDAYå½æ°ï¼è®¡ç®åæ°ä¸æå®æ¥ææå¼ç¨åå
æ ¼ä¸çæ¥æ天æ°ã
ãDCOUNTå½æ°ï¼è¿åæ°æ®åºæå表çåä¸æ»¡è¶³æå®æ¡ä»¶å¹¶ä¸å
å«æ°åçåå
æ ¼æ°ç®ã
ãFREQUENCYå½æ°ï¼ä»¥ä¸ååç´æ°ç»è¿åæ个åºåä¸æ°æ®çé¢çåå¸ã
ãIFå½æ°ï¼æ ¹æ®å¯¹æå®æ¡ä»¶çé»è¾å¤æççåç»æï¼è¿åç¸å¯¹åºæ¡ä»¶è§¦åç计ç®ç»æã
ãINDEXå½æ°ï¼è¿åå表ææ°ç»ä¸çå
ç´ å¼ï¼æ¤å
ç´ ç±è¡åºå·åååºå·çç´¢å¼å¼è¿è¡ç¡®å®ã
ãINTå½æ°ï¼å°æ°å¼åä¸åæ´ä¸ºææ¥è¿çæ´æ°ã
ãISERRORå½æ°ï¼ç¨äºæµè¯å½æ°å¼è¿åçæ°å¼æ¯å¦æéãå¦ææéï¼è¯¥å½æ°è¿åTRUEï¼åä¹è¿åFALSEã
ãLEFTå½æ°ï¼ä»ä¸ä¸ªææ¬å符串ç第ä¸ä¸ªå符å¼å§ï¼æªåæå®æ°ç®çå符ã
ãLENå½æ°ï¼ç»è®¡ææ¬å符串ä¸å符æ°ç®ã
ãMATCHå½æ°ï¼è¿åå¨æå®æ¹å¼ä¸ä¸æå®æ°å¼å¹é
çæ°ç»ä¸å
ç´ çç¸åºä½ç½®ã
ãMAXå½æ° ï¼æ±åºä¸ç»æ°ä¸çæ大å¼ã
ãMIDå½æ°ï¼ä»ä¸ä¸ªææ¬å符串çæå®ä½ç½®å¼å§ï¼æªåæå®æ°ç®çå符ã
ãMINå½æ°ï¼æ±åºä¸ç»æ°ä¸çæå°å¼ã
ãMODå½æ°ï¼æ±åºä¸¤æ°ç¸é¤çä½æ°ã
ãMONTHå½æ°ï¼æ±åºæå®æ¥ææå¼ç¨åå
æ ¼ä¸çæ¥æçæ份ã
ãNOWå½æ°ï¼ç»åºå½åç³»ç»æ¥æåæ¶é´ã
ãORå½æ°ï¼ä»
å½ææåæ°å¼å为é»è¾âåï¼FALSEï¼âæ¶è¿åç»æé»è¾âåï¼FALSEï¼âï¼å¦åé½è¿åé»è¾âçï¼TRUEï¼âã
ãRANKå½æ°ï¼è¿åæä¸æ°å¼å¨ä¸åæ°å¼ä¸çç¸å¯¹äºå
¶ä»æ°å¼çæä½ã
ãRIGHTå½æ°ï¼ä»ä¸ä¸ªææ¬å符串çæåä¸ä¸ªå符å¼å§ï¼æªåæå®æ°ç®çå符ã
ãSUBTOTALå½æ°ï¼è¿åå表ææ°æ®åºä¸çåç±»æ±æ»ã
ãSUM å½æ°ï¼è®¡ç®ææåæ°æ°å¼çåã
ãSUMIFå½æ°ï¼è®¡ç®ç¬¦åæå®æ¡ä»¶çåå
æ ¼åºåå
çæ°å¼åã
ãTEXTå½æ°ï¼æ ¹æ®æå®çæ°å¼æ ¼å¼å°ç¸åºçæ°å转æ¢ä¸ºææ¬å½¢å¼ã
ãTODAYå½æ°ï¼ç»åºç³»ç»æ¥æã
ãVALUEå½æ°ï¼å°ä¸ä¸ªä»£è¡¨æ°å¼çææ¬åå符串转æ¢ä¸ºæ°å¼åã
ãVLOOKUPå½æ°ï¼å¨æ°æ®è¡¨çé¦åæ¥æ¾æå®çæ°å¼ï¼å¹¶ç±æ¤è¿åæ°æ®è¡¨å½åè¡ä¸æå®åå¤çæ°å¼ã
ãWEEKDAYå½æ°ï¼ç»åºæå®æ¥æ对åºçæææ°ã
温馨提示:答案为网友推荐,仅供参考