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

¨Ì¥¼µ²¼Æ¤Î¦^Âмƶqªº±Æµ{¡A¦p¦ó®Ö¹ï¨ìµ²³æ¤é´Á???

¨Ì¥¼µ²¼Æ¤Î¦^Âмƶqªº±Æµ{¡A¦p¦ó®Ö¹ï¨ìµ²³æ¤é´Á???

¦pªþ¥ó¡A­q³æ¼Æ¤À§O©ó10/1~10/18¤À§O¤J®w¡]©ó10/18¥æ²M¡^¡A¦p¦ó¥H¤½¦¡¦Û°Ê®»¨ú¨ì10/18¦¹¤é´Á¡A¥H«K©óBÄæ¦ì¥i¦Û°Ê®M¨ú­pºâ¥X·í¤U¨äL/T¸ê®Æ????
½Ð¦U¦ì°ª¤â«ü±Ð¡AÁÂÁÂ....

Book3.rar (4.91 KB)

=DAYS360(TODAY(),LOOKUP(9^9,$A2:$AV2,$A$1:$AV$1))

TOP

·PÁÂANGELA ¥S¦p¦¹§Ö³tªº¦^ÂСAªGµM¥i¥H¦Û°Ê®M¨ú¥X¸Ó¤é´Á¡A¦ý°õ¦æ«á¤p§Ì¤S¦³¤G¤p°ÝÃD½Ð°Ý¡G

1.®£¦³®É¼Æ¶q·|¦³¦^Âпù»~¡A¨Ò¡G­ì¥¼µ²1,500K¡A©ó10/18§Y¤wµ²²M¡A¦ý¤H¬°KEY IN¿ù»~¡A©ó10/24¤S¦AKEY IN¼Æ¶q®É¡A¤½¦¡¤´·|®M¨ú¨ì10/24¡A¦ý³o¼ËL/T¤Ñ¼Æ¼Æ¾Ú´N¦³¿ù¤F
2.©µ¦ù²Ä¤@°ÝÃD¡A§Æ±æ°£¤F¦b¤ñ¹ï¨ì¸Ó¤é´Á¥~¤]¯à°µ®Ö¹ï¥¼µ²¼Æ»P¦^ÂÐ¥æ´Áªº¼Æ¶q®Ö¹ï¡A¦p±Æµ{¤W¼Æ¶q¤£¨¬¡A§Y¨q¥X"©|¦³XXK¼Æ¶q¥¼¦^"¡A¦p±Æµ{¼Æ¶q¶W¹L¡A§Y¨q"±Æµ{¼Æ¤w¶W¹L¥¼µ²­q³æ¼Æ¤F®@"¡A¦p±Æµ{¼Æ»P¥¼µ²¼Æ¬Û²Å¡A§Y¨q¥X©óXX/XX¡]¤ë/¤é¡^OO¤Ñ¡]´X¤Ñ«á¡^¥i±N¥¼µ²­q³æ¥æ²M"

TOP

=IF(SUM(C2:IV2)>A2,"±Æµ{¼Æ¤w¶W¹L¥¼µ²­q³æ¼Æ¤F®@",IF(SUM(C2:IV2)<A2,"©|¦³"&ABS(SUM(C2:IV2)-A2)&"¼Æ¶q¥¼¦^",TEXT(LOOKUP(9^9,$A2:$AV2,$A$1:$AV$1),"m¤ëd¤é  ")&LOOKUP(9^9,$A2:$AV2,$A$1:$AV$1)-TODAY()&"¤Ñ«á¥i±N¥¼µ²­q³æ¥æ²M"))

TOP

·PÁÂANGELA ¥S¦^ÂСA¤p§Ì¬Q¤é¤]¦³·Q¤F¤@¤U¡A­×§ïªº¤j­P¸òANGELA¥S¤@¼Ë

¥ý³]©w±ø¥ó§P©w¡A¦p­q³æ¼Æ¶W¹L§Y¤£·|¦³¤½¦¡®M¨ú¿ù»~¼Æ¾Úªº°ÝÃD¡A¦A¦¸·PÁÂ

¤½¦¡¤£¸Ñ½Ð°Ý¡G9^9ªº·N«ä¬O???

TOP

¦^´_ 5# p6703


      9^9=  387420489   9ªº9¦¸¤è
  ¤@¯ë¬O¥Î9.9e+307   EXCEL¥i¥Îªº³Ì¤j¼Æ
  ³o­Ó¼Æ¥u­n¤j¹L¸ê®Æ¤¤ªº³Ì¤j¼Æ§Y¥i¡C

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD