ifº¯Êý¶à¸öÌõ¼þÔõôÓà ifº¯Êý¶à¸öÌõ¼þÈçºÎʹÓð¡

ÍõÃ÷¸Õ

1¡¢º¯Êý¹«Ê½ÈçÏ£º=if£¨A1>=50%,³©Ïú¿î,if(And(A1>=30%,A1<50%),ƽÏú¿î,if(A1<30%,ÖÍÏú¿î))£©

2¡¢¾ßÌå½âÊÍÈçÏ£º¹«Ê½£º=IF(Ìõ¼þ1,·µ»Ø½á¹û1,IF(Ìõ¼þ2,·µ»Ø½á¹û2,IF(Ìõ¼þ3,·µ»Ø½á¹û3£¬....)))£¨Ô­Àí¾ÍÊÇÏÈÅжÏÌõ¼þ1ÊÇ·ñ³ÉÁ¢£¬Èç¹ûÌõ¼þ1³ÉÁ¢Ôò·µ»Ø½á¹û1£¬·ñÔò½øÈëÌõ¼þ2ÅжÏÊÇ·ñ³ÉÁ¢£¬Èç¹û³ÉÁ¢¾Í·µ»Ø½á¹û2£¬·ñÔò½øÈëÌõ¼þ3Åжϣ¬...Èç´ËÀàÍÆ.£©¡£