ååæåçä½ çé®é¢ï¼
æè¿°ä¸ï¼âA1æ¯5ï¼A2æ¯3âï¼ä½æªå¾ä¸ææA1ï¼1ï¼A2ï¼2ï¼ä¸æè¿°å®å
¨å¯¹ä¸ä¸å·ï¼æ以æªå¾çè¾
å©ä½ç¨å°±å¤§ä¸ºä¸éãåæ ·æè¿°ä¸âB1æ¯3ï¼B2æ¯0ï¼B3æ¾ç¤º3âï¼ä½æªå¾ä¸B1ï¼3ï¼B2ï¼0ï¼B1ä¹ä¸ä¸ä¸è´ï¼ä¸B3æ¾ç¤ºç0ï¼ï¼å¨B5代表B3éè¦çç»æå§ï¼ãæ以对äºä½ çæªå¾æ¯å¦æ¯ä½ æè¿°çé®é¢æ æ³ç¡®å®ã
ä¸é£ä¸ªé®é¢ä¸æ ·ï¼Aåä¸Båçè§åä¸ä¸æ ·ï¼è¿ç§ä¸ä¸æ ·åæ¯æ¥ç¡®å®ï¼
å¦æè½å¤ç¡®å®æªå¾ä¸ç¬¬5çæ°æ®æ¯éè¦çæ£ç¡®ç»æï¼èä¸ç®¡æåæè¿°çè¯ï¼é£ä¹ä¸é¢çå
¬å¼å³å¯ï¼
A3=(MOD(A1-1,9)+1)*(A2>0)
å³æ
追é®æ表达ä¸æ¸
æ¥æè¿ä¹åçï¼æªå¾ææ¯ææ³è¡¨è¾¾çï¼A2åºç°0æ¶A3æ¾ç¤º0ï¼åºç°1æè
大äº1æ¶A3æ¾ç¤ºA1æ°å¼
å¤§å¤§ä½ é£å
¬å¼åè¿å»æ示é误
追çå¤å¶å·¥ä½è¡¨ä¸çå
¬å¼æ¶ï¼å°äºå·¦è¾¹çæ¬å·ï¼å·²ä¿®æ£ã