ifå½æ°ï¼æç®åçå°±æ¯1级ï¼éAå³B.
IF(C,A,B) è¿éC表示æ¡ä»¶å ¬å¼ï¼å¦æC=TRUE,åç»æ为A,å¦å为B.
2007ççexcelï¼IFå½æ°æå¤å¯ä»¥åµå¥64å±ã
ä¸è¬å®é åºç¨ä¸ï¼ä¸ä¼ç¨å°é£ä¹å¤åµå¥çãä¸é¢ä¸¾ä¸ªä¾å说æä¸ä¸ã
ä¾å¦æè¡¨æ ¼å¦å¾ï¼
第ä¸æ¥ï¼å¨C2è¾å
¥å
¬å¼ï¼=IF(B2>=60ï¼âåæ ¼","ä¸åæ ¼"),并å°è¯¥å
¬å¼ä¸æè³C6.
第äºæ¥ï¼å¨D2è¾å ¥å ¬å¼ï¼=IF(B2>=90,"ä¼",IF(B2>=80,"è¯",IF(B2>=70,"ä¸",IF(B2>=60,"ä¸è¬","å·®"))))ï¼å¹¶ä¸æè³D6.ç»æå¦å¾ï¼
âANDâæ¯é»è¾è¿ç®çè¿ç®ç¬¦ï¼å¨æ¡ä»¶å
¬å¼Cä¸å¯ä»¥ä½¿ç¨ANDè¿ç®ç¬¦ï¼ä¹å¯ä»¥ç¨ANDå½æ°ã