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

«D¼Ð·Ç®É¶¡®æ¦¡¡A¸ÓÀx¦s®æ¦Û°ÊÅܦâ

«D¼Ð·Ç®É¶¡®æ¦¡¡A¸ÓÀx¦s®æ¦Û°ÊÅܦâ

Dear all,
§Ú·Q¦bÀx¦s®æ¤º³]©w(±ø¥ó¦¡®æ¦¡³]©w)¡G·í¸ÓÄæ¦ì¤H¤u¿é¤J¸ê®Æ®É¨Ã«D¬O¼Ð·Ç®É¶¡®æ¦¡¡A¸ÓÀx¦s®æ¦Û°ÊÅܦâ
½Ð°Ý­n«ç»ò³]©w¡H¨Ï¥Î­þ¤@¨ç¼Æ©O¡H
ÁÂÁ¡I

¶À¦â©³³¡¤À¡A§Ú§Æ±æ¬O«D®É¶¡®æ¦¡®É¡A¥¦·|¦Û°ÊÅܦâ




«D¼Ð·Ç®É¶¡®æ¦¡¡A¸ÓÀx¦s®æ¦Û°ÊÅܦâ.rar (7.43 KB)
Just do it.

¦^´_ 1# jsc0518


½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ

«D¼Ð·Ç®É¶¡®æ¦¡¡A¸ÓÀx¦s®æ¦Û°ÊÅܦâ.zip (7.59 KB)

TOP

¦^´_ 2# samwang

±z¦n¡I·PÁ±zªº¦^ÂСC
¦A°Ý¤@¤U¡A¦³¿ìªk³s"¤é´Á"³£¥i¥H¥d¶Ü¡H§Ú¥u§Æ±æ³oÄæ¦ì¥u¦³ hh:mm




Thank you so much.
Just do it.

TOP

¥»©«³Ì«á¥Ñ samwang ©ó 2021-4-22 13:07 ½s¿è

¦^´_ 3# jsc0518

½Ð¦A´ú¸Õ¬Ý¬Ý¡AÁÂÁ¡C

«D¼Ð·Ç®É¶¡®æ¦¡¡A¸ÓÀx¦s®æ¦Û°ÊÅܦâ2.zip (7.61 KB)

TOP

¦^´_ 4# samwang

¥i¥H¤F¡A¤Ó·PÁ§A¤F¡C
¥i¥H±Ð§Ú³o»yªkªº·N«ä¶Ü¡H¡H¡H

=(CELL("format",A2)<>"D9")*(CELL("type",A2)<>"b")+ISTEXT(A2)
Just do it.

TOP

¦^´_ 4# samwang


  µo²{¤@°ÝÃD¡A¿é¤J5.18¡A¥¦·|Åܦ¨®É¶¡

TEST.gif
Just do it.

TOP

¦^´_  samwang


  µo²{¤@°ÝÃD¡A¿é¤J5.18¡A¥¦·|Åܦ¨®É¶¡
jsc0518 µoªí©ó 2021-4-22 13:41



µo²{¨ä¥L°ÝÃD

ERROR.gif
Just do it.

TOP

¥»©«³Ì«á¥Ñ samwang ©ó 2021-4-22 14:01 ½s¿è

¦^´_ 6# jsc0518

¦pªG§âAÄæ³]¬°³q¥Î®æ¦¡¡A²Ä¤@¦¸¿é¤J¬°¤é´Á®æ¦¡¡A¸ÓÀx¦s®æ´N·|³]¬°®É¶¡®æ¦¡¡A
¦p¤S¿é¤J5.18¡A«h´N·|µø¬°¼Æ¦r®æ¦¡±j¨î§ï¬°®É¶¡®æ¦¡
§Ú¦Û¤v¤]ı±o«Ü©_©Ç¡A
³o¥i¯à­n½Ð¨ä¥L¤j¤j¨Ó¸Ñ´b¤F
ÁÂÁ¡C

TOP

½Ð±Ð¤@¤U¦U¦ì¤j¤j¡A°w¹ï³oÃD°ÝÃD¦³¦ó¬Ýªk©Î¸Ñªk?? ·PÁÂ

TOP

=ISERR(A2*1)+(A2>1)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD