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

[µo°Ý] ¦p¦óÅý»¼¼Wªº¼Æ­È¤£·|¶Ã±¼???

[µo°Ý] ¦p¦óÅý»¼¼Wªº¼Æ­È¤£·|¶Ã±¼???

=IF($A$1="","",IF(ROW()<=$A$1/50,50*ROW(),""))

°²³]A1Äæ¦ì 1500  ¦ÓBÄæ ¥Î³o¤½¦¡«h·|¨Ì·ÓA1¼Æ­È¤w50 100 150 »¼¼W¨ì1500
¦ý¦]¬°¤G­ÓÄæ¦ì¤£¤@©w·|±qA1 B1¶}©l «h¼Æ­È·|¶Ã±¼  
¤£ª¾¹D¤j¤j¬O§_¦³¿ìªkÅý¼Æ­È¤£·|¶Ã±¼??

¦^´_ 1# a31075ha

=IF($A$1="","",IF(ROW(A1)<=$A$1/50,50*ROW(A1),""))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 1# a31075ha


     =IF(ROW(A1)>$A$1/50,"",ROW(A1)*50)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# Hsieh

·PÁÂ2¦ì¤j¤jªºÀ°¦£.....¸Ñ¨M¤p§Ìªº§xÂZ..............................
¦]¬°¹ï³o­Ó¤£¤Ó¦æ

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD