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

[µo°Ý] ®æ¦¡¤Æ±ø¥ó³]©w

[µo°Ý] ®æ¦¡¤Æ±ø¥ó³]©w

½Ð±Ð¦U¦ì¥ý¶i:

AÄ檺­È¤p©óµ¥©ó$L$1,¦ý¤£¥]§t0,
²Å¦X±ø¥ó«h¥Î¶Â©³²Ê¥Õ¦r,
§Ú¤£ª¾¹D¤£¥]§t0­n¦p¦ó¼g¶i±ø¥ó¦¡¤¤?

®æ¦¡¤Æ±ø¥ó.zip (7.29 KB)

¦^´_ 1# PJChen
ss

TOP

¬Û¹ï©óA1®æªº³]©w®æ¦¡¤Æ±ø¥ó(ª½±µ¿ï¨úAÄæ³]©w¤ñ¸û§Ö)
=AND(A1<>0, A1<=$L$1)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# ML089
¦^´_ 2# sunnyso

·PÁ¤G¦ì´£¨Ñªº¤½¦¡,°õ¦æok.
¥Î¤F¦n¤@°}¤lªº®æ¦¡¤Æ±ø¥ó,³£¤£ª¾¹D¥i¥Hkey-in¤½¦¡...
·PÁ«ü¾É!!

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD