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

[µo°Ý] ¦p¦óÀ³¥Î¼Æ­È,²£¥Íµ²ªG

[µo°Ý] ¦p¦óÀ³¥Î¼Æ­È,²£¥Íµ²ªG

¥»©«³Ì«á¥Ñ ybh891026 ©ó 2016-11-22 11:49 ½s¿è

½Ð±Ð¦U¦ì«e½ú,¦pÀɮפW¤º®e¤Wªº°ÝÃD,«D±`·PÁÂ

6.gif (108.05 KB)

6.gif

66.rar (8.12 KB)

¥»©«³Ì«á¥Ñ p212 ©ó 2016-11-23 09:25 ½s¿è

¦^´_ 1# ybh891026
½Ð°Ñ¦Ò¡I

66_ref.zip (12.46 KB)

TOP

C3="¼Æ­È"&IF((A2<A3)*(A3>0),"¤W¤É","¤U­°")&",Á`¶q"&IF((B2<B3)*(B3>0),"¤W¤É","¤U­°")
D3=IF((A2<A3)*(A3>0),IF((B2<B3)*(B3>0),"±j¶Õ","À£¤OÅÜ®z"),IF((B2>B3)+(B3<0),"®z¶Õ","À£¤O¼W±j"))

TOP

¦^´_ 2# p212
P¤j,«D±`·PÁ±z«ü¾É~¾Ç²ß¤F

TOP

¦^´_ 3# hcm19522
H¤j~«D±`·PÁ±z«ü¾É~¤w¥i¥H¨Ï¥Î¤F~

TOP

¥»©«³Ì«á¥Ñ ybh891026 ©ó 2016-11-23 11:55 ½s¿è

¦^´_ 2# p212


    P¤j,½Ð±Ð±z¤@­Ó°ÝÃD~(µû½×CÄæ¦ìµ²ªG)¨ºÄæ¦ì,  ¦pªGÅã¥Ü±j¶Õ&À£¤OÅÜ®z¥i¥HÅܦ¨¬õ¦â   À£¤O¼W±j&®z¶Õ¥i¥HÅܦ¨ºñ¦â
    ¦p¤U­±¹Ï¤ù   ·PÁ±z

·s¹Ï¤ù1.gif (14.72 KB)

·s¹Ï¤ù1.gif

TOP

D2Àx¦s®æ³]©w
®æ¦¡-³]©w®æ¦¡¤Æ±ø¥ó-¤½¦¡¬°
¤º³]©w¦p¤U 2±ø¥ó
=IF(OR($D2="±j¶Õ",$D2="À£¤OÅÜ®z"),TRUE,FALSE)   ®æ¦¡¿ïÀx¦s®æ¶ñº¡¬õ¦â
=IF(OR($D2="®z¶Õ",$D2="À£¤O¼W±j"),TRUE,FALSE)   ®æ¦¡¿ïÀx¦s®æ¶ñº¡ºñ¦â
ÂлsD2Àx¦s®æ®æ¦¡¦Ü D3-D65536 §Y¥i
ù

TOP

http://blog.xuite.net/hcm19522/twblog/471615508

TOP

¦^´_ 6# ybh891026
½Ð°Ñ¦Ò¡I

66_ref2.zip (12.68 KB)

TOP

¦^´_ 7# rouber590324
r¤j~·PÁÂ~¾Ç²ß¤F~³]©w§¹¦¨

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD