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

¨âÄæ¸ê®Æ¤ñ¹ï«á§PÂ_¬O§_¿ù»~

¨âÄæ¸ê®Æ¤ñ¹ï«á§PÂ_¬O§_¿ù»~

¿Ë·Rªº¤j¤j­Ì..

§Ú·Q¶i¦æA & BÄ椤 A1 B1 / A2 B2 /A3 B3... ¨â¨â¤ñ¹ï¼Æ­È¡C

­YBÄæ"¬Y¤@­Ó"¼Æ­È¤j©óAÄæ¼Æ­È2­¿,«h¦bC1Åã¥Ü"§PÂ_¿ù»~"

½Ð°Ý­Y¤£¨Ï¥ÎVAB­n¦p¦ó°µ©O? :L

»¡©ú.jpg
Jack

¦^´_ 1# vackbin

¤½¦¡¸Ô¸Ñ¡A½Ð°Ñ¦Ò¡Ghttps://goo.gl/me4T3B

TOP

·PÁÂjoblyc017¤j¤jªº¦^ÂÐ~~
´ú¸Õ«áµo²{¡A­Y¤ñ¹ï³æ¯Âªº¼Æ­È¨S¦³°ÝÃD¡C
¦ý¬O¦pªG¬O¤ñ¹ï½d³ò¦³ªÅ®æ¡Aµ²ªG´N¥X²{"#VALUE!"
½Ð°Ý³o¯à¸Ñ¨M¶Ü? Orz
Jack

TOP

¦^´_ 3# vackbin


°}¦C¤½¦¡:
=IF(COUNT(0/(B2:B99-A2:A99*2>0)),"§PÂ_¿ù»~","")

TOP

·PÁ ­ã´£³¡ªL ¤j¤j~~
¸g´ú¸Õ«áµ²ªG¥¿½T¡A¤w¤£¨ü"ªÅ®æ"¼vÅT¤F
·PÁ¨â¦ì¤j¤jªº¦^ÂÐ~~
¤µ¤Ñ»{ÃѤF"N"¨ç¼Æ³o­Ó·sªB¤Í¡A¨þ¨þ¨þ~
"°ÝÃD¤w¸g¸Ñ¨M"
Jack

TOP

        ÀR«ä¦Û¦b : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD