示æå¾å¦ä¸:
å¨D10ä¸è¾å ¥å ¬å¼:=IF(ROW(A10)<4,"",IF(SUM(IF(MOD(A10,ROW(INDIRECT("2:"&INT(A10/2))))>0,0,1))=0,"",SUM(IF(MOD(A10,ROW(INDIRECT("2:"&INT(A10/2))))>0,0,1))))
åæ¶æä¸ENTERé®,SHIFTé®,åCTRLé®.
å¨C10ä¸è¾å ¥å ¬å¼:=IF(D10="","ç´ æ°","")
ææ°å¡«å¨A10å¤,å¦ææ¯ç´ æ°,ç»æ马ä¸å¨C10å¤åºæ¥äº.å¦ææ¯åæ°,D10ä¼åè¯ä½ å ¶å åæå¤å°ä¸ª.é常精确,ä¸ä¿¡,æ¨è¯è¯.
å¦ææAååæèªç¶æ°åºå,ç¸å¯¹åºå°,æä¸¤ä¸ªå ¬å¼å¾ä¸æä¹å¯ä»¥å!åªæ¯,æ°ç»å ¬å¼å¼å¤ªå¤äº,计ç®æºè¿è¡èµ·æ¥ä¼å¾æ ¢ç.
æä¸ä¸ªé®é¢è¦åè¯æ¨,å¨è¿å¿,A10ä¸çæ°ä¸å¯ä»¥å¤§äº 2097153,æ³æ³è¿æ¯ä¸ºä»ä¹?!
æ1997å¡«å ¥A10ä¸,ç»ææ¯ç´ æ°.