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

¦b¨ç¼Æ¤¤¦p¦ó«ü¥Ü¥t¨ç¼Æµ²ªG¬°#N/Aªº­È¡H

¦b¨ç¼Æ¤¤¦p¦ó«ü¥Ü¥t¨ç¼Æµ²ªG¬°#N/Aªº­È¡H

¤£ª¾¹D§Úªº»¡©ú¬O§_¥¿½T¡A§Úªº·N«ä¬O¤ñ¦p§Ú¥ÎIF¨ç¼Æ¡A·í¬Y¨ç¼Æµ²ªG¬°#N/A®É¡A§YÅã¥Ü¡uµL¦¹¸ê®Æ¡v¡A§_«h§Y¦p¦ó¦p¦ó¡C
½Ð°Ý§ÚÀ³¦p¦ó«ü©w#N/A³o­Ó¤Þ¼Æ¡HÁÂÁÂ

=IF(ISERR(~~),"µL¦¹¸ê®Æ",~~)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522


    «D±`·PÁ¶O¤ß«ü¾É¡I
¤£¹L¸Õ¤F¤@¤U¡AISERR( )¡AÀ³¸Ó­×§ï¦¨ISERROR( )¤~¾A¥Î¡C¦]¬°«eªÌ¤£¥]§t#N/A¡C

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD