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

[µo°Ý] ½Ð°Ý­n¦³¤°¨ç¼Æ¥i¥H§PÂ_®É¶¡¨Ó¤À¥X¤é¡B©]¯Z

¦^´_ 7# ML089


  "  =IF((MOD(A2,1)>--"7:40")*(MOD(A2,1)<=--"19:40"),"¤é¯Z","©]¯Z")
" B2 =LOOKUP(MOD(A2,1),--{0,"7:40","19:41"},{"©]","¤é","©]"})&"¯Z"

½Ð°Ý -- ¬O¬Æ»ò¹Bºâªº·N«ä

ÁÂÁÂ¥ý

TOP

¦^´_ 11# Scott090

-- ´N¬O¼Æ¾Ç¹Bºâ ­t­tªº¥¿¡AEXCEL ªºTRUE/FALSE ¦b¼Æ¾Ç¹Bºâ¤¤·|Âର 1/0 ¨Ó³B²z¡A¤å¦r¼Æ¦r©Î¤é´Á¡B®É¶¡¤]¬Û¦P·|Âର¼Æ­È­pºâ¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 12# ML089


    §®¡A ·P®¦
¦bVBA ªº»¡©ú¤º¦n¹³§ä¤£¨ì¦p¦¹ªºÂà´«ªk

TOP

¦^´_ 13# Scott090

VBA »P ¤½¦¡½T¹ê¤£¤@­P

--"12", 1*"12" VBA¤Î¤½¦¡³£¥i¥H

¤é´Á»P®É¶¡¤å¦rÂà´«¤½¦¡¥i¥H¡AVBAµLªk³B²z
--"8:00", 1*"8:00"
--"2015/8/20",
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 1# 52ee24

¨Æ¹ê¤W¡A³oÃD¦³¬Û·í¦hªº¸Ñªk¡A¨ä¤¤ªº¤@Ãþ¡A¨Ï¥Î "®æ¦¡¦Û©w¸q" +"¨ç¼Æ" :

1) B1 >> ®æ¦¡¦Û©w¸q >> ¿é¤J :  [=0]©]¯Z;[=1]¤é¯Z

2.1) ¨Ï¥Î PROB ¨ç¼Æ, B1¿é¤J¤½¦¡ :

=PROB(MOD(A1,1),1,0.319,0.819)

2.2) ©ÎªÌ, ¨Ï¥Î FREQUENCY ¨ç¼Æ, B1¿é¤J¤½¦¡ :

=FREQUENCY(MOD(A1,1),{0.819,0.319})

TOP

¦^´_ 14# ML089

Àx¦s®æªº«¬ºA¦³®É«ÜÀǬN¡A°£«D¥[¤@­Ó " ' "±j½Õ¬O¤å¦r«¬ºA
³o¬O§Úªº¬Ýªk

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD