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

[µo°Ý] ¤é´Á +7 «á ¦p¸ÓÄæµL¿é¤J «h¤£Åã¥Ü

[µo°Ý] ¤é´Á +7 «á ¦p¸ÓÄæµL¿é¤J «h¤£Åã¥Ü

¤½¥qCUE SHEETªí §Æ±æ²£¥Í¤U¶g¤é´Á  
=IF(AC4<>0,AC4+$AA$2,"")  ¦p¸ÓÄæ«D¬°ªÅ¥Õ ¥»©P¤é´Á+7
¦ý±NAD ¨º¦æ(¤U¶g)ªº­È½Æ»s¨ìAC¦æ(¥»¶g)®É
ªÅ¥ÕÄæ²£¥Í#vaule
¨D¸Ñ THANKS

QUESTION.JPG (181.24 KB)

QUESTION.JPG

¨SªþÀÉ®×¥u¯à¥Î²qªº¡CACÄ榳¬Ý¤£¨£ªº¦r¤¸©Î¤½¦¡,¨Ã«D¯uªÅ¡C

TOP

¦^´_ 1# Ä|¤l


    [ac]Äæ¦ì µL¸ê®Æ¥i¹ï·Ó.. AAÄæ¦ì¤]µL¸ê®Æ..(¹Ï­±¤W¨Ó¬Ýªº¸Ü..

  ¦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

¦^´_ 2# ANGELA

ADÄæ=ACÄæ+7
ADÄæ ªº­È½Æ»s¨ì ACÄæ®É²£¥Í #value
½Ð±Ð¦p¦ó¦b½Æ»s¹Lµ{²£¥Í¦¹¤@²{¶H ©Î ­×§ïADÄ椽¦¡     =IF(AC12<>0,AC12+$AA$2,"") ¨Ó¸Ñ¨M
¥H¤W¶Ç THANKS
    ªÅ¥Õcuesheet(¤Å§R).zip (22.77 KB)

TOP

¦^´_ 4# Ä|¤l

¨S¬Ý¿ùªº¸Ü
ACÄæ¦ì ¬O ¤é´Á..
AD Äæ¦ì¬O¤½¦¡..
AD Äæ¦ìªº­È ¬O±q ACÄæ¦ì ­pºâ¹L¨Óªº..
ACÄæ¦ì ªº­È ®Ú¾Ú¦b­þ?
­YACÄæ¦ì¨S®Ú¾Úªº¸Ü AC­È«ç¥X¨Ó?
ÁÙ¦³
AD ½Æ»s¹L¥h«á¡A­Y¨S¯S®í¯S©wªº¸Ü¡A¨Ì·Ó¹w³] ¤½¦¡¤ºªº  = IF(AC13<>0,AC13+$AA$2,"")  ·|Åܦ¨ =IF(AB13<>0,AB13+$AA$2,"") .. AB Äæ¦ì ¨S¦³¼Æ¾Ú..
¤½¦¡Âà´«¹L¥h... ·íµM¥X¿ù£¾£¾"

  ¦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

¦^´_ 5# mark15jill

ªí³æ¥Øªº¬O«ö¥»¶g¤w¦³¼½¥X¤é´Á +7 ²£¥Í¤U¶g¼½¥X¤é´Á
¨C¶g­«¼½¦¸¼Æ¤£¤@©w(20¦¸¥H¤º) ¼½¥X®É¬q©T©w(EX:¨C¶g¤@, ¤Tªº¼½¥X®É¶¡¬Û¦P)
¦ýµL¼½¥X®É §Æ±æ¸ÓÄæ¦ì«O«ù µLÅã¥Ü(°ÝÃD©Ò¦b)
    AC¬°¥»¶g  AD¬°¤U¶g ¬G AD=AC+7
¦A§â AD ½Æ»s ­È¨ì AC ¤S¦A²£¥Í¤U¤U¶g

TOP

¦^´_ 6# Ä|¤l
¬O³o¼Ë¶Ü?
AC4=IF(F4<>"",F4+7,"")
AD4=IF(AC4="","",AC4+$AA$2)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 7# Hsieh
¬Ý¤£¨£ªºAA2=7
EXCELÀÉ ¤w¤W¶Ç
ªí³æ¥Øªº¬O«ö¥»¶g¤w¦³¼½¥X¤é´Á +7 ²£¥Í¤U¶g¼½¥X¤é´Á

    AC¬°¥»¶g  AD¬°¤U¶g ¬G AD=AC+7
¦A§â AD ½Æ»s ­È¨ì AC ¤S¦A²£¥Í¤U¤U¶g©óADÄæ
°ÝÃD¥X¦b 13¦C¥H¤U ¨S¦³¤é´Áªº³¡¥÷ ¸g¹L¤½¦¡¹Bºâ ³y¦¨ #VALUE
½Ð±Ð°ª¤âÀ³¦p¦óÁקK?
¥¨¶°«ü¥O§P§O«á§R°£¥ç¥i ªÅ¥Õcuesheet(¤Å§R).zip (22.77 KB)

TOP

试试

=IF(N(AC11),AC11+7,"")

TOP

ADÄæCOPY¨ìAC13®É¥Î¿ï¾Ü©Ê¶K¤W.
©Î
AC13=AC4+7
¦V¤UCOPY

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD