ifå¥ç¨é®é¢ï¼å¯è½å
³ç³»äºæ¹é¢ï¼ä¸æ¯å
¬å¼æä¹åï¼äºæ¯æ°æ®å¤çä¸æä¹å¤æï¼
å
¬å¼åæ³ï¼=if(å¤æ对éï¼å¯¹æ¶æ¾ç¤ºç»æï¼éæ¶æ¾ç¤ºç»æï¼ï¼å¦:=if(a1>1,1,0);
å两个ç»æåå«å¯ä»¥æ¢æif()å
¬å¼ãå¦ï¼
=if(a1>1,if(a1>10,3,1),0)
=if(a1>1,1,if(a1>0,0,-5))
计ç®æºè®¡ç®æ¶ï¼æ¯ä»æå¤å±ifå¼å§è®¡ç®çï¼å°±æ¯å
å¤ææ左边ï¼ç¬¬ä¸ä¸ªifï¼ï¼ï¼æ以å¦æå¤æè¾å¤æ¶ï¼å¯ä»¥åªç¨
大äºå·>,æ
å°äºå·ï¼å¦ä¸é¢ã
ä¾å¦ï¼æå·¥å计件å¥å±ï¼å®æçä½äº70%æ å¥éï¼å¤§äºçäº70%ä¸ä»¶æ£0.5å
ï¼å¤§äºçäº86%çä¸ä»¶æ£0.3å
ï¼100%çå¥1000å
ï¼å¤äº100%çä¸ä»¶å¥1å
ãæ°æ®å¨A2ï¼å®æçå¨B2ï¼ä»»å¡æ°éå¨E2ï¼å
¬å¼ï¼
=IF(B2>1,1000+A2-$E$2,IF(B2=1,1000,IF(B2>=0.86,-($E$2-A2)*0.3+1000,IF(B2>=0.7,-($E$2-A2)*0.5+1000,0))))