ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¨D§U¡H­Y¦¹¦C¥ô¦ó¤@­ÓÀx¦s®æ ¶W¥X·Ç«h ½d³ò¥H¥~«h F §_«h P

[µo°Ý] ¨D§U¡H­Y¦¹¦C¥ô¦ó¤@­ÓÀx¦s®æ ¶W¥X·Ç«h ½d³ò¥H¥~«h F §_«h P

¤p©f¦³¤@ÃøÃD­n¦U¦ì®v­ôÀ°¦£¡A§_«h´Nµ¹¦ÑÁó駡
­Y¦¹¦C¥ô¦ó¤@­ÓÀx¦s®æ
¶W¥X·Ç«h ½d³ò¥H¥~«h F §_«h P

¸Ô¨£ªþ¥ó¡AÁÂÁ¡I

Test2.zip (42.16 KB)

Hello all !

AO7=IF(SUMPRODUCT(((S7:AN7<>0)*((S7:AN7<0.03)+(S7:AN7>0.06))))>0,"F","P")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD