ããå¦ä¸ï¼
ããIf(E4>550<=633,633,If(E4<550,550,If(E4>633<=666,666,If(E4>666<=700,700,If(E4>700<=733,733,If(E4>733<= 800,800,If(E4>800<=833,833,If(E4>833<=900,900,If(E4>900<= 950,950,If(E4>950<= 1000,1000,If(E4>1000<=1050,1050,If(E4>1050<=1100,1100,If(E4>1100<=1150,1150,If(E4>1150<=1200,1200,If(E4>1200<=1250,1250,If(E4>1250<=1300,1300,If(E4>1300<=1350,1350,If(E4>1350<=1400,1400,If(E4>1400<=1450,1450,If(E4>1450<=1500,1500,If(E4>1500<=1550,1550,If(E4>1550<=1600,1600,If(E4>1600<=1650,1650,If(E4>1650<=1700,1700,If(E4>1700<=1800,1800,E4)))))))))))))))))))))))))
IFå½æ°æä¸ä¸ªåæ°ï¼è¯æ³å¦ä¸ï¼
ãã1ã=IF(æ¡ä»¶å¤æ, ç»æ为çè¿åå¼, ç»æ为åè¿åå¼)
ãã第ä¸åæ°æ¯æ¡ä»¶å¤æï¼æ¯å¦è¯´âA1="ç¾åº¦"âæâ21>37âè¿ç§ï¼ç»æè¿åTRUEæFALSEãå¦æå¤æè¿åTRUEé£ä¹IFå½æ°è¿åå¼æ¯ç¬¬äºåæ°ï¼å¦åè¿å第ä¸åæ°ã
ãã2ã=IF(1>2,"å¤æç","å¤æå")
ããå
¶ä¸å¤æ1大äº2ç»ææ¯åä¹å°±æ¯FALSEï¼æ以åå
æ ¼è¿å第ä¸åæ°ææ¬âå¤æåâã
ãã3ã第ä¸åæ°å¨æäºæ
åµä¸ä¸æ¯ç¨æ¯è¾å¤æ符å·æ¥å¤æçãExcelä¸å°0认为æ¯FALSEï¼é0å¼çä»·äºTRUEãæ以å¦ä¸å¾ï¼B1å
¬å¼ä¸ºï¼
ãã=IF(SUM(A1:A2),"å¤æç","å¤æå")
ããå 为A1:A2å计大äº0ï¼æ以è¿å第äºåæ°ææ¬âå¤æçâã
温馨提示:答案为网友推荐,仅供参考