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

Ãö©óexcel¹Ïªí

Ãö©óexcel¹Ïªí

·íexcel¹Ïªí¸ê®Æ¨Ó·½²£¥Í#N/A©Î#REF! ¹Ïªí·|¥¢¯u©Î¾ã­Ó®ø¥¢ ½Ð°Ý¦³¤°»ò¸É±Ïªº¤èªk£v??

¥»©«³Ì«á¥Ñ mark15jill ©ó 2012-10-25 10:32 ½s¿è
·íexcel¹Ïªí¸ê®Æ¨Ó·½²£¥Í#N/A©Î#REF! ¹Ïªí·|¥¢¯u©Î¾ã­Ó®ø¥¢ ½Ð°Ý¦³¤°»ò¸É±Ïªº¤èªk£v??
ddhh4053 µoªí©ó 2012-10-24 22:43


1.§ä¦^­ì©l¨Ó·½¸ê®Æ(¥]§t¦ì¸m¡B«¬ºA¡B¼Æ­È)
2.§ó·s¸ê®Æ¨Ó·½¡A§ó§ï¦Ü¦³®Ä¸ê®Æ¨Ó·½
3.­Y¥H¤W¨âºØ³£µLªk¨Ï¥Î¡A«Øij­«·s³]©w¸ê®Æ¨Ó·½§a..
²£¥Í¨º¨âºØ±¡§Î¡A¦³¥i¯à¬O ¨Ó·½¦ì¸mµLªk¿ëÃÑ¡B¸ê®Æ«¬ºA¤£²Å©Î¬O ¦³¤å¦r+¼Æ¦r ¼Æ¦r+¤å¦r¤§Ãþªº¤£¦P®æ¦¡¹Bºâ

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

·íexcel¹Ïªí¸ê®Æ¨Ó·½²£¥Í#N/A©Î#REF! ¹Ïªí·|¥¢¯u©Î¾ã­Ó®ø¥¢ ½Ð°Ý¦³¤°»ò¸É±Ïªº¤èªk£v??
ddhh4053 µoªí©ó 2012-10-24 22:43

°²³] A1 (¼¯®t) ­È¬° #REF! ¡A A1 Ä椽¦¡³]©w¦p¤U¡G
=IF(ISERROR(YESDDE!Q2),0,YESDDE!Q2)
¸Õ¸Õ¬Ý¡C

TOP

®¦®¦  ³o­Ó¤½¦¡ªº·N«ä¬°¦ó? ¥Î¦bVBA¤]¦æ£v ¼gªk¦p¦ó  ÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD