1ãSUMå½æ°ï¼SUMå½æ°çä½ç¨æ¯æ±åãå½æ°å ¬å¼ä¸º=sumï¼ï¼
ä¾å¦ï¼ç»è®¡ä¸ä¸ªåå æ ¼åºåï¼=sum(A1:A10) ç»è®¡å¤ä¸ªåå æ ¼åºåï¼=sum(A1:A10,C1:C10)
2ãAVERAGEå½æ°:Average çä½ç¨æ¯è®¡ç®å¹³åæ°ãå½æ°å ¬å¼ä¸º=AVERAGE( )
ä¾å¦ï¼è®¡ç®å¤ä¸ªåå æ ¼çå¹³åå¼=AVERAGE(A1:A12ï¼
3ãcountå½æ°ï¼ä½ç¨æ¯è®¡ç®åå æ ¼ä¸ªæ° ãå½æ°å ¬å¼ä¸º=COUNT( )
ä¾å¦=COUNT(A1:A12)
4ãIFå½æ°ï¼IFå½æ°çä½ç¨æ¯å¤æä¸ä¸ªæ¡ä»¶ï¼ç¶åæ ¹æ®å¤æçç»æè¿åæå®å¼ã
IFå½æ°å ¬å¼ä¸ºï¼=IF(é»è¾å¤æ,为TRUEæ¶çç»æ,为FALSEæ¶çç»æ)
ä¾å¦ï¼ç»åºçæ¡ä»¶æ¯A1>A5ï¼å¦ææ¯è¾ç»ææ¯TRUEï¼é£ä¹IFå½æ°å°±è¿å第äºä¸ªåæ°çå¼;å¦ææ¯FALSEï¼åè¿å第ä¸ä¸ªåæ°çå¼ã=IF(A1>A5,1,2)
5ãNOWå½æ°åTODAYå½æ°ï¼NOWå½æ°è¿åæ¥æåæ¶é´ãTODAYå½æ°ååªè¿åæ¥æã
NOWå½æ°åTODAYå½æ°é½æ²¡æåæ°ï¼åªç¨ä¸å¯¹æ¬å·å³å¯ï¼=NOW()=TODAY()
åå¦è¯´ï¼è¦è®¡ç®æ项ç®å°ä»å¤©æ»å ±è¿è¡å¤å°å¤©äº?=TODAY()-å¼å§æ¥æï¼å¾åºçæ°åå°±æ¯é¡¹ç®è¿è¡ç天æ°ã
6ãVLOOKUPå½æ°ï¼VLOOKUPå½æ°ç¨æ¥å¨è¡¨æ ¼ä¸æ¥æ¾æ°æ®ã
å½æ°çè¯æ³å ¬å¼æ¯ï¼=VLOOKUP(æ¥æ¾å¼,åºå,è¦è¿å第å åçå 容,1è¿ä¼¼å¹é 0精确å¹é )