뢽슼䄠?뎣폃닙ퟷ뗄뿬뷝볼?릤ퟷ늾닙ퟷ?듲뾪릤ퟷ늾 Ctrl+O 놣듦릤ퟷ늾 Ctrl+S 맘뇕톡뚨뗄릤ퟷ늾뒰뿚 Ctrl+W믲Ctrl+F4 믖뢴톡뚨릤ퟷ늾뒰뿚뗄듳킡 Ctrl+F5 ퟮ듳뮯톡뚨릤ퟷ늾뒰뿚 Ctrl+F10 ퟮ킡뮯톡뚨릤ퟷ늾뒰뿚 Ctrl+F9 쟐뮻떽쿂튻룶릤ퟷ늾뒰뿚 Ctrl+F6 쟐뮻떽짏튻룶릤ퟷ늾뒰뿚 Ctrl+Shift+F6 릤ퟷ뇭닙ퟷ?뒴붨탂릤ퟷ뇭 Ctrl+N 쿲뫳쟐뮻릤ퟷ뇭 Ctrl+PageDown 쿲잰쟐뮻릤ퟷ뇭 Ctrl+PageUp 듲펡풤샀 Alt+F퓙내V 듲펡 Ctrl+P 믹놾닙ퟷ?뎷쿺짏늽닙ퟷ Ctrl+Z 믖뢴짏늽닙ퟷ Ctrl+Y 훘뢴짏늽닙ퟷ F4 보쟐 Ctrl+X 뢴훆 Ctrl+C 햳쳹 Ctrl+V 닩헒 Ctrl+F 쳦뮻 Ctrl+H 뚨캻 Ctrl+G 닥죫엺힢 Shift+F2
뷜돏2컄 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 듲뾪ꆰ닥죫몯쫽ꆱ뛔뮰뿲 Shift+F3 뚨틥쏻돆 Ctrl+ F3 톡퓱닙ퟷ?톡퓱떥풪룱쯹퓚헻쇐ꎨ떥풪룱뒦폚뇠벭ힴ첬ꎩ Ctrl+Shift+뿕룱 톡퓱헻룶릤ퟷ뇭 Ctrl+A 톡퓱뛠룶풪쯘 내힡Ctrl퓙떥믷룷룶풪쯘 떥풪룱닙ퟷ?듲뾪ꆰ떥풪룱룱쪽ꆱ뛔뮰뿲 Ctrl+1 듲뾪ꆰ퇹쪽ꆱ뛔뮰뿲 Ctrl+’ 짨훃떥풪룱캪ꆰ뎣맦ꆱ쫽ퟖ룱쪽 Ctrl+Shift+ꆫ 짨훃떥풪룱캪솽캻킡쫽뗄믵뇒룱쪽 Ctrl+Shift+$ 짨훃떥풪룱캪늻듸킡쫽뗄냙럖뇈룱쪽 Ctrl+Shift+ꎥ 짨훃떥풪룱캪솽캻킡쫽뗄뿆톧볆쫽룱쪽 Ctrl+Shift+ ^짨훃떥풪룱캪몬폐쓪퓂죕뗄죕웚룱쪽 Ctrl+Shift+# 짨훃떥풪룱캪몬폐킡쪱럖훓틔벰짏쿂컧뗄쪱볤룱쪽 Ctrl+Shift+@ 짨훃떥풪룱캪솽캻킡쫽쟒폐잧캻럖룴럻뗄쫽ퟖ룱쪽 Ctrl+Shift+! 뛔ퟖ쳥뷸탐볓듖믲좡쿻볓듖 Ctrl+B 뛔ퟖ쳥뷸탐쟣킱믲좡쿻쟣킱 Ctrl+I 뛔ퟖ쳥볓쿂뮮쿟믲좡쿻쿂뮮쿟 Ctrl+U 쫤죫닙ퟷ?쫤죫떱잰죕웚 Ctrl+ꎻ 쫤죫떱잰쪱볤 Ctrl+Shift+ꎺ 퓚떥풪룱훐쫤죫믘뎵 Alt+Enter 쿲쿂쳮돤쫤죫 Ctrl+D 쿲폒쳮돤쫤죫 Ctrl+R 웤쯻닙ퟷ?쿔쪾놻톡쿮뗄뿬뷝닋떥 Shift+F10 쿔쪾믲틾님ꆰ뎣폃ꆱ릤뻟삸 Ctrl+7 닥죫뎬솴뷓 Ctrl+K 2
뢽슼 뢽슼䈠?몯쫽쯷틽?닆컱몯쫽?䑂?릦쓜ꎺ쪹폃만뚨폠뛮뗝복램ꎬ볆쯣튻뇊닺퓚룸뚨웚볤쓚뗄헛뻉횵ꆣ 뇭듯쪽ꎺDBꎨcostꎬsalvageꎬlifeꎬperiodꎬmonthꎩ 닎쫽몬틥ꎺ Cost 캪닺풭횵ꆣ Salvage 캪닺퓚헛뻉웚쒩뗄볛횵ꎨ튲돆캪닺닐횵ꎩꆣ Life 캪헛뻉웚쿞ꎨ폐쪱튲돆ퟷ닺뗄쪹폃쫙쏼ꎩꆣ Period 캪탨튪볆쯣헛뻉횵뗄웚볤ꆣPeriod뇘탫쪹폃폫life쿠춬뗄떥캻ꆣ Month 캪뗚튻쓪뗄퓂럝쫽ꎬ죧쪡싔ꎬ퓲볙짨캪12ꆣ 䑄??릦쓜ꎺ쪹폃쮫놶폠뛮뗝복램믲웤쯻횸뚨랽램ꎬ볆쯣튻뇊닺퓚룸뚨웚볤쓚뗄헛뻉횵ꆣ 뇭듯쪽ꎺDDBꎨcostꎬsalvageꎬlifeꎬperiodꎬfactorꎩ 닎쫽몬틥ꎺ Cost 캪닺풭횵ꆣ Salvage 캪닺퓚헛뻉웚쒩뗄볛횵ꎨ튲돆캪닺닐횵ꎩꆣ Life 캪헛뻉웚쿞ꎨ폐쪱튲돆ퟷ닺뗄쪹폃쫙쏼ꎩꆣ Period 캪탨튪볆쯣헛뻉횵뗄웚볤ꆣPeriod뇘탫쪹폃폫life쿠춬뗄떥캻ꆣ Factor 캪폠뛮뗝복쯙싊ꆣ죧맻factor놻쪡싔ꎬ퓲볙짨캪2ꎨ쮫놶폠뛮뗝복램ꎩꆣ 䙖?릦쓜ꎺ믹폚만뚨샻싊벰뗈뛮럖웚뢶뿮랽쪽ꎬ략믘쒳쿮춶뗄캴살횵ꆣ 뇭듯쪽ꎺFVꎨrateꎬnperꎬpmtꎬpvꎬtypeꎩ 닎쫽몬틥ꎺ Rate 캪룷웚샻싊ꆣ Nper 캪ퟜ춶웚ꎬ벴룃쿮춶뗄뢶뿮웚ퟜ쫽ꆣ 뷰뛮ꎬ웤쫽횵퓚헻룶쓪뷰웚볤놣돖늻뇤ꆣ춨뎣pmt냼삨놾뷰뫍샻쾢ꎬPmt캪룷웚쯹펦횧뢶뗄 떫늻냼삨웤쯻럑폃벰쮰뿮ꆣ죧맻뫶싔pmtꎬ퓲뇘탫냼삨pv닎쫽ꆣ 캪쿖횵ꎬ벴듓룃쿮춶뾪쪼볆쯣쪱틑뺭죫헊뗄뿮쿮ꎬ믲튻쾵쇐캴살뢶뿮뗄떱잰횵뗄샛Pv 믽뫍ꎬ튲돆캪놾뷰ꆣ죧맻쪡싔PVꎬ퓲볙짨웤횵캪쇣ꎬ늢쟒뇘탫냼삨pmt닎쫽ꆣ 3
뷜돏4컄 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 Type쫽ퟖ0믲1ꎬ폃틔횸뚨룷웚뗄뢶뿮쪱볤쫇퓚웚쒩뮹쫇웚돵ꆣ죧맻쪡싔typeꎬ퓲볙짨웤횵 캪쇣ꆣ 䥐䵔?릦쓜ꎺ믹폚만뚨샻싊벰뗈뛮럖웚뢶뿮랽쪽ꎬ략믘룸뚨웚쫽쓚뛔춶뗄샻쾢뎥뮹뛮ꆣ 뇭듯쪽ꎺIPMTꎨrateꎬperꎬnperꎬpvꎬfvꎬtypeꎩ 닎쫽몬틥ꎺ Rate 캪룷웚샻싊ꆣ Per 폃폚볆쯣웤샻쾢쫽뛮뗄웚쫽ꎬ뇘탫퓚1떽nper횮볤ꆣ Nper 캪ퟜ춶웚ꎬ벴룃쿮춶뗄뢶뿮웚ퟜ쫽ꆣ 캪쿖횵ꎬ벴듓룃쿮춶뾪쪼볆쯣쪱틑뺭죫헊뗄뿮쿮ꎬ믲튻쾵쇐캴살뢶뿮뗄떱잰횵뗄샛Pv 믽뫍ꎬ튲돆캪놾뷰ꆣ 캪캴살횵ꎬ믲퓚ퟮ뫳튻듎뢶뿮뫳쾣췻뗃떽뗄쿖뷰폠뛮ꆣ죧맻쪡싔 fvꎬ퓲볙짨웤횵캪쇣Fv ꎨ샽죧ꎬ튻뇊듻뿮뗄캴살횵벴캪쇣ꎩꆣ Type쫽ퟖ0믲1ꎬ폃틔횸뚨룷웚뗄뢶뿮쪱볤쫇퓚웚쒩뮹쫇웚돵ꆣ죧맻쪡싔typeꎬ퓲볙짨웤횵 캪쇣ꆣ 䥒??릦쓜ꎺ략믘평쫽횵듺뇭뗄튻ퟩ쿖뷰쇷뗄쓚늿쫕틦싊ꆣ 쳘뗣ꎺ헢킩쿖뷰쇷늻뇘캪뻹뫢뗄ꎬ떫ퟷ캪쓪뷰ꎬ쯼쏇뇘탫내만뚨뗄볤룴닺짺ꎬ죧내퓂믲내쓪ꆣ쓚늿쫕틦싊캪춶뗄믘쫕샻싊ꎬ웤훐냼몬뚨웚횧뢶ꎨ뢺횵ꎩ뫍뚨웚쫕죫ꎨ헽횵ꎩꆣ 뇭듯쪽ꎺIRRꎨvaluesꎬguessꎩ 닎쫽몬틥ꎺ Values캪쫽ퟩ믲떥풪룱뗄틽폃ꎬ냼몬폃살볆쯣략믘뗄쓚늿쫕틦싊뗄쫽ퟖꆣValues뇘탫냼몬훁 짙튻룶헽횵뫍튻룶뢺횵ꎬ틔볆쯣략믘뗄쓚늿쫕틦싊ꆣ 캪뛔몯쫽IRR볆쯣뷡맻뗄맀볆횵ꆣ퓚듳뛠쫽쟩뿶쿂ꎬ늢늻탨튪캪몯쫽IRR뗄볆쯣쳡릩Guess guess횵ꆣ죧맻쪡싔 guessꎬ볙짨쯼캪ꎨ10%ꎩꆣ죧맻몯쫽IRR략믘듭컳횵#NUM!ꎬ믲뷡맻쎻폐뾿뷼웚췻횵ꎬ뿉폃쇭튻룶guess횵퓙쫔튻듎ꆣ 䥓偍??릦쓜ꎺ볆쯣쳘뚨춶웚쓚튪횧뢶뗄샻쾢ꆣ 뇭듯쪽ꎺISPMTꎨrateꎬperꎬnperꎬpvꎩ 닎쫽몬틥ꎺ Rate 캪춶뗄샻싊ꆣ Per 캪튪볆쯣샻쾢뗄웚쫽ꎬ듋횵뇘탫퓚1떽nper횮볤ꆣ Nper 캪춶뗄ퟜ횧뢶웚쫽ꆣ Pv 캪춶뗄떱잰횵ꆣ뛔폚듻뿮ꎬpv캪듻뿮쫽뛮ꆣ 䵉剒?릦쓜ꎺ략믘쒳튻솬탸웚볤쓚쿖뷰쇷뗄탞헽쓚늿쫕틦싊ꆣ 쳘뗣ꎺ몯쫽MIRR춬쪱뾼싇쇋춶뗄돉놾뫍쿖뷰퓙춶뗄쫕틦싊ꆣ 4
뢽슼 뇭듯쪽ꎺMIRRꎨvaluesꎬfinance_rateꎬreinvest_rateꎩ 닎쫽몬틥ꎺ Values캪튻룶쫽ퟩ믲뛔냼몬쫽ퟖ뗄떥풪룱뗄틽폃ꆣ헢킩쫽횵듺뇭ퟅ룷웚뗄튻쾵쇐횧 돶ꎨ뢺횵ꎩ벰쫕죫ꎨ헽횵ꎩꆣ Finance_rate 캪쿖뷰쇷훐쪹폃뗄뷰횧뢶뗄샻싊ꆣ Reinvest_rate 캪붫쿖뷰쇷퓙춶뗄쫕틦싊ꆣ 乐䕒?릦쓜ꎺ믹폚만뚨샻싊벰뗈뛮럖웚뢶뿮랽쪽ꎬ략믘쒳쿮춶뗄ퟜ웚쫽ꆣ 뇭듯쪽ꎺNPERꎨrateꎬ pmtꎬ pvꎬ fvꎬ typeꎩ 닎쫽몬틥ꎺ Rate 캪룷웚샻싊ꎬ쫇튻만뚨횵ꆣ Pmt캪룷웚쯹펦횧뢶뗄뷰뛮ꎬ웤쫽횵퓚헻룶쓪뷰웚볤놣돖늻뇤ꆣ춨뎣ꎬpmt냼삨놾뷰뫍샻 쾢ꎬ떫늻냼삨웤쯻뗄럑폃벰쮰뿮ꆣ 캪쿖횵ꎬ벴듓룃쿮춶뾪쪼볆쯣쪱틑뺭죫헊뗄뿮쿮ꎬ믲튻쾵쇐캴살뢶뿮뗄떱잰횵뗄샛Pv 믽뫍ꎬ튲돆캪놾뷰ꆣ 캪캴살횵ꎬ믲퓚ퟮ뫳튻듎뢶뿮뫳쾣췻뗃떽뗄쿖뷰폠뛮ꆣ죧맻쪡싔fvꎬ퓲볙짨웤횵캪쇣Fv ꎨ샽죧ꎬ튻뇊듻뿮뗄캴살횵벴캪쇣ꎩꆣ Type 쫽ퟖ0믲1ꎬ폃틔횸뚨룷웚뗄뢶뿮쪱볤쫇퓚웚쒩뮹쫇웚돵ꆣ 乐??릦쓜ꎺ춨맽쪹폃쳹쿖싊틔벰튻쾵쇐캴살횧돶ꎨ뢺횵ꎩ뫍쫕죫ꎨ헽횵ꎩꎬ략믘튻쿮춶뗄뺻쿖횵ꆣ 뇭듯쪽ꎺNPVꎨrateꎬvalue1ꎬvalue2ꎬ ...ꎩ 닎쫽몬틥ꎺ Rate 캪쒳튻웚볤뗄쳹쿖싊ꎬ쫇튻만뚨횵ꆣ Value1ꎬ캪 떽29룶닎2ꎬ쫽ꎬ듺뇭횧돶벰쫕죫ꆣ퓚쪱볤짏뇘탫뻟폐쿠뗈볤룴ꎬ늢쟒뚼랢 value ... 짺퓚웚쒩ꆣ 偍??릦쓜ꎺ믹폚만뚨샻싊벰뗈뛮럖웚뢶뿮랽쪽ꎬ략믘듻뿮뗄쎿웚뢶뿮뛮ꆣ 뇭듯쪽ꎺPMTꎨrateꎬnperꎬpvꎬfvꎬtypeꎩ 닎쫽몬틥ꎺ Rate 듻뿮샻싊ꆣ Nper 룃쿮듻뿮뗄뢶뿮ퟜ쫽ꆣ Pv 쿖횵ꎬ믲튻쾵쇐캴살뢶뿮뗄떱잰횵뗄샛믽뫍ꎬ튲돆캪놾뷰ꆣ 캪캴살횵ꎬ믲퓚ퟮ뫳튻듎뢶뿮뫳쾣췻뗃떽뗄쿖뷰폠뛮ꎬ죧맻쪡싔fvꎬ퓲볙짨웤횵캪쇣ꎬFv 튲뻍쫇튻뇊듻뿮뗄캴살횵캪쇣ꆣ Type 쫽ퟖ0믲1ꎬ폃틔횸뚨룷웚뗄뢶뿮쪱볤쫇퓚웚쒩뮹쫇웚돵ꆣ 5
뷜돏6컄 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 偐䵔?릦쓜ꎺ믹폚만뚨샻싊벰뗈뛮럖웚뢶뿮랽쪽ꎬ략믘춶퓚쒳튻룸뚨웚볤쓚뗄놾뷰뎥뮹뛮ꆣ 뇭듯쪽ꎺPPMTꎨrateꎬperꎬnperꎬpvꎬfvꎬtypeꎩ 닎쫽몬틥ꎺ Rate 캪룷웚샻싊ꆣ Per 폃폚볆쯣웤놾뷰쫽뛮뗄웚쫽ꎬ뇘탫뷩폚1떽nper횮볤ꆣ Nper 캪ퟜ춶웚ꎬ벴룃쿮춶뗄뢶뿮웚ퟜ쫽ꆣ 캪쿖횵ꎬ벴듓룃쿮춶뾪쪼볆쯣쪱틑뺭죫헊뗄뿮쿮ꎬ믲튻쾵쇐캴살뢶뿮떱잰횵뗄샛믽Pv 뫍ꎬ튲돆캪놾뷰ꆣ 캪캴살횵ꎬ믲퓚ퟮ뫳튻듎뢶뿮뫳쾣췻뗃떽뗄쿖뷰폠뛮ꎬ죧맻쪡싔fvꎬ퓲볙짨웤횵캪쇣ꎬFv 튲뻍쫇튻뇊듻뿮뗄캴살횵캪쇣ꆣ Type 쫽ퟖ0믲1ꎬ폃틔횸뚨룷웚뗄뢶뿮쪱볤쫇퓚웚쒩뮹쫇웚돵ꆣ 偖?릦쓜ꎺ략믘춶뗄쿖횵ꆣ쿖횵캪튻쾵쇐캴살뢶뿮뗄떱잰횵뗄샛믽뫍ꆣ 뇭듯쪽ꎺPVꎨrateꎬnperꎬpmtꎬfvꎬtypeꎩ 닎쫽몬틥ꎺ Rate 캪룷웚샻싊ꆣ Nper 캪ퟜ춶ꎨ믲듻뿮ꎩ웚ꎬ벴룃쿮춶ꎨ믲듻뿮ꎩ뗄뢶뿮웚ퟜ쫽ꆣ 캪룷웚쯹펦횧뢶뗄뷰뛮ꎬ웤쫽횵퓚헻룶쓪뷰웚볤놣돖늻Pmt뇤ꆣ춨뎣pmt 삨놾뷰뫍샻쾢ꎬ 떫늻냼삨웤쯻럑폃벰쮰뿮ꆣ 캪캴살횵ꎬ믲퓚ퟮ뫳튻듎횧뢶뫳쾣췻뗃떽뗄쿖뷰폠뛮ꎬ죧맻쪡싔fvꎬ퓲볙짨웤횵캪쇣Fv ꎨ튻뇊듻뿮뗄캴살횵벴캪쇣ꎩꆣ Type 쫽ퟖ0믲1ꎬ폃틔횸뚨룷웚뗄뢶뿮쪱볤쫇퓚웚쒩뮹쫇웚돵ꆣ 剁呅?릦쓜ꎺ략믘쓪뷰뗄룷웚샻싊ꆣ 뇭듯쪽ꎺRATEꎨnperꎬpmtꎬpvꎬfvꎬtypeꎬguessꎩ 닎쫽몬틥ꎺ Nper 캪ퟜ춶웚ꎬ벴룃쿮춶뗄뢶뿮웚ퟜ쫽ꆣ Pmt캪룷웚뢶뿮뛮ꎬ웤쫽횵퓚헻룶춶웚쓚놣돖늻뇤ꆣ춨뎣pmt냼삨놾뷰뫍샻쾢ꎬ떫늻냼 삨웤쯻럑폃믲쮰뷰ꆣ죧맻뫶싔쇋pmtꎬ퓲뇘탫냼몬fv닎쫽ꆣ 캪쿖횵ꎬ벴듓룃쿮춶뾪쪼볆쯣쪱틑뺭죫헊뗄뿮쿮ꎬ믲튻쾵쇐캴살뢶뿮떱잰횵뗄샛믽Pv 뫍ꎬ튲돆캪놾뷰ꆣ 캪캴살횵ꎬ믲퓚ퟮ뫳튻듎뢶뿮뫳쾣췻뗃떽뗄쿖뷰폠뛮ꆣ죧맻쪡싔fvꎬ퓲볙짨웤횵캪쇣Fv ꎨ샽죧ꎬ튻뇊듻뿮뗄캴살횵벴캪쇣ꎩꆣ Type 쫽ퟖ0믲1ꎬ폃틔횸뚨룷웚뗄뢶뿮쪱볤쫇퓚웚쒩뮹쫇웚돵ꆣ Guess 캪풤웚샻싊ꆣ죧맻쪡싔풤웚샻싊ꎬ퓲볙짨룃횵캪10%ꆣ 6
뢽슼 卌??릦쓜ꎺ략믘쒳쿮닺퓚튻룶웚볤훐뗄쿟탔헛뻉횵ꆣ 뇭듯쪽ꎺSLNꎨcostꎬsalvageꎬlifeꎩ 닎쫽몬틥ꎺ Cost 캪닺풭횵ꆣ Salvage 캪닺퓚헛뻉웚쒩뗄볛횵ꎨ튲돆캪닺닐횵ꎩꆣ Life 캪헛뻉웚쿞ꎨ폐쪱튲돆ퟷ닺뗄쪹폃쫙쏼ꎩꆣ 卙??릦쓜ꎺ략믘쒳쿮닺내쓪쿞ퟜ뫍헛뻉램볆쯣뗄횸뚨웚볤뗄헛뻉횵ꆣ 뇭듯쪽ꎺSYDꎨcostꎬsalvageꎬlifeꎬperꎩ 닎쫽몬틥ꎺ Cost 캪닺풭횵ꆣ Salvage 캪닺퓚헛뻉웚쒩뗄볛횵ꎨ튲돆캪닺닐횵ꎩꆣ Life 캪헛뻉웚쿞ꎨ폐쪱튲돆ퟷ닺뗄쪹폃쫙쏼ꎩꆣ Per 캪웚볤ꎬ웤떥캻폫life쿠춬ꆣ 噄??릦쓜ꎺ쪹폃쮫놶폠뛮뗝복램믲웤쯻횸뚨뗄랽램ꎬ략믘횸뚨뗄죎뫎웚볤쓚ꎨ냼삨늿럖웚볤ꎩ뗄닺헛뻉횵ꆣ 뇭듯쪽ꎺVDBꎨcostꎬsalvageꎬlifeꎬstart_periodꎬend_periodꎬfactorꎬno_switchꎩ 닎쫽몬틥ꎺ Cost 캪닺풭횵ꆣ Salvage 캪닺퓚헛뻉웚쒩뗄볛횵ꎨ튲돆캪닺닐횵ꎩꆣ Life 캪헛뻉웚쿞ꎨ폐쪱튲돆ퟷ닺뗄쪹폃쫙쏼ꎩꆣ Start_period 캪뷸탐헛뻉볆쯣뗄웰쪼웚볤ꎬStart_period뇘탫폫life뗄떥캻쿠춬ꆣ End_period 캪뷸탐헛뻉볆쯣뗄뷘횹웚볤ꎬEnd_period뇘탫폫life뗄떥캻쿠춬ꆣ 캪폠뛮뗝복쯙싊ꎨ헛뻉틲ퟓꎩꎬ죧맻쪡싔닎쫽factorꎬ퓲몯쫽볙짨factor캪 2ꎨ쮫Factor 놶폠뛮뗝복램ꎩꆣ 캪튻싟벭횵ꎬ횸뚨떱헛뻉횵듳폚폠뛮뗝복볆쯣횵쪱ꎬ쫇럱폃횱쿟헛뻉램ꆣ캪No_switch TRUEꎬ벴쪹헛뻉횵듳폚폠뛮뗝복볆쯣횵ꎬMicrosoft Excel튲늻폃횱쿟헛뻉램; 캪FALSE 믲놻뫶싔ꎬ쟒헛뻉횵듳폚폠뛮뗝복볆쯣횵쪱ꎬExcel붫폃쿟탔헛뻉램ꆣ 죕웚폫쪱볤몯쫽?䑁呅?릦쓜ꎺ략믘듺뇭쳘뚨죕웚뗄탲쇐뫅ꆣ 뇭듯쪽ꎺDATEꎨyearꎬmonthꎬdayꎩ 7
뷜돏8컄 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 닎쫽몬틥ꎺ Year 뿉틔캪튻떽쯄캻쫽ퟖꆣMicrosoft Excel 붫룹뻝쯹쪹폃뗄죕웚쾵춳살뷢쫍year닎쫽ꆣ Month Month 듺뇭쎿쓪훐퓂럝뗄쫽ퟖꆣ Day 듺뇭퓚룃퓂럝훐뗚벸쳬뗄쫽ퟖꆣ 䑁呅噁䱕??릦쓜ꎺ붫틔컄놾뇭쪾뗄죕웚뮻돉튻룶탲쇐뫅ꆣ 뇭듯쪽ꎺDATEVALUEꎨdate_textꎩ 닎쫽몬틥ꎺ Date_text듺뇭틔Microsoft Excel죕웚룱쪽뇭쪾뗄죕웚뗄컄놾ꆣ샽죧ꎬ"2008-1-30" 믲 "30-Jan-08" 뻍쫇듸틽뫅뗄컄놾ꎬ쯼폃폚듺뇭죕웚ꆣ 䑁??릦쓜ꎺ략믘틔탲쇐뫅뇭쪾뗄쒳죕웚뗄쳬쫽ꎬ폃헻쫽1떽31뇭쪾ꆣ 뇭듯쪽ꎺDAYꎨserial_numberꎩ 닎쫽몬틥ꎺ Serial_number 캪튪닩헒뗄쓇튻쳬뗄죕웚ꆣ 䑁奓㌶??릦쓜ꎺ내헕튻쓪360쳬뗄쯣램ꎨ쎿룶퓂틔30쳬볆ꎬ튻쓪릲볆12룶퓂ꎩꎬ략믘솽죕웚볤쿠닮뗄쳬쫽. 뇭듯쪽ꎺDAYS360ꎨstart_dateꎬend_dateꎬmethodꎩ 닎쫽몬틥ꎺ Start_date 폃폚볆쯣웚볤쳬쫽뗄웰쪼죕웚 End_date 폃폚볆쯣웚볤쳬쫽뗄훐횹죕웚 캪튻룶싟벭횵ꎬ쯼횸뚨쇋퓚볆쯣훐쫇닉폃얷훞랽램뮹쫇쏀맺랽램ꆣ쫤FALSE믲쪡싔뇭쪾쏀맺랽램 ꎨNASDꎩꎬ벴죧맻웰쪼죕웚쫇튻룶퓂뗄31뫅ꎬ퓲뗈폚춬퓂뗄30Method 뫅ꎻ죧맻훕횹죕웚쫇튻룶퓂뗄31뫅ꎬ늢쟒웰쪼죕웚퓧폚30뫅ꎬ퓲훕횹죕웚뗈폚쿂튻룶퓂뗄1뫅ꎬ럱퓲ꎬ훕횹죕웚뗈폚놾퓂뗄30뫅ꆣ쫤죫TRUE뇭쪾얷훞랽램ꎬ웰쪼죕웚뫍훕횹죕웚캪튻룶퓂뗄31뫅ꎬ뚼붫뗈폚놾퓂뗄30뫅ꆣ 䡏啒?릦쓜ꎺ략믘쪱볤횵뗄킡쪱쫽ꆣ벴튻룶뷩폚0 ꎨ12:00 .ꎩ떽23 ꎨ11:00 .ꎩ횮볤뗄헻쫽ꆣ 뇭듯쪽ꎺHOURꎨserial_numberꎩ 닎쫽몬틥ꎺ Serial_number 뇭쪾튻룶쪱볤횵ꎬ웤훐냼몬튪닩헒뗄킡쪱ꆣ샽죧ꎺ"6:45 PM"ꆣ 䵉乕呅?릦쓜ꎺ략믘쪱볤횵훐뗄럖훓ꎬ캪튻룶뷩폚0떽59횮볤뗄헻쫽ꆣ 뇭듯쪽ꎺMINUTEꎨserial_numberꎩ 8
뢽슼 닎쫽몬틥ꎺ Serial_number 뇭쪾튻룶쪱볤횵ꎬ웤훐냼몬튪닩헒뗄럖훓ꆣ샽죧ꎺ"6:45 PM"ꆣ 䵏乔??릦쓜ꎺ략믘틔탲쇐뫅뇭쪾뗄죕웚훐뗄퓂럝ꆣ퓂럝쫇뷩폚1ꎨ튻퓂ꎩ떽12ꎨ쪮뛾퓂ꎩ횮볤뗄헻쫽ꆣ 뇭듯쪽ꎺMONTHꎨserial_numberꎩ 닎쫽몬틥ꎺ Serial_number 뇭쪾튻룶죕웚횵ꎬ웤훐냼몬튪닩헒뗄퓂럝ꆣ 乏??릦쓜ꎺ략믘떱잰죕웚뫍쪱볤쯹뛔펦뗄탲쇐뫅ꆣ 뇭듯쪽ꎺNOWꎨ ꎩ 卅䍏乄?릦쓜ꎺ략믘쪱볤횵뗄쏫쫽ꆣ략믘뗄쏫쫽캪0떽59횮볤뗄헻쫽ꆣ 뇭듯쪽ꎺSECONDꎨserial_numberꎩ 닎쫽몬틥ꎺ Serial_number 뇭쪾튻룶쪱볤횵ꎬ웤훐냼몬튪닩헒뗄쏫쫽ꆣ샽죧ꎺ"6:45 PM"ꆣ 呉䵅?릦쓜ꎺ략믘쒳튻쳘뚨쪱볤뗄킡쫽횵ꆣ 뇭듯쪽ꎺTIMEꎨhourꎬminuteꎬsecondꎩ 닎쫽몬틥ꎺ Hour 캪0ꎨ쇣ꎩ떽32767횮볤뗄쫽횵ꎬ듺뇭킡쪱ꆣ Minute 캪0떽32767횮볤뗄쫽횵ꎬ듺뇭럖훓ꆣ Second 캪0떽32767횮볤뗄쫽횵ꎬ듺뇭쏫ꆣ 呉䵅噁䱕??릦쓜ꎺ략믘평컄놾ퟖ럻뒮쯹듺뇭뗄쪱볤뗄킡쫽횵ꆣ 뇭듯쪽ꎺTIMEVALUEꎨtime_textꎩ 닎쫽몬틥ꎺ Time_text컄놾ퟖ럻뒮ꎬ듺뇭틔Microsoft Excel쪱볤룱쪽뇭쪾뗄쪱볤ꎨ샽죧ꎬ듺뇭쪱볤 뗄뻟폐틽뫅뗄컄놾ퟖ럻뒮"6:45 PM"뫍"18:45"ꎩꆣ 呏䑁??릦쓜ꎺ략믘떱잰죕웚뗄탲쇐뫅ꆣ 뇭듯쪽ꎺTODAYꎨ ꎩ 坅䕋䑁??릦쓜ꎺ략믘쒳죕웚캪탇웚벸ꆣ 뇭듯쪽ꎺWEEKDAYꎨserial_numberꎬreturn_typeꎩ 9
뷜돏1컄0 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 닎쫽몬틥ꎺ Serial_number 뇭쪾튻룶쮳탲뗄탲쇐뫅ꎬ듺뇭튪닩헒뗄쓇튻쳬뗄죕웚ꆣ 캪좷뚨략믘횵샠탍뗄쫽ퟖꆣ쫤죫1믲쪡싔략믘횵캪쫽ퟖ1ꎨ탇웚죕ꎩ떽쫽ퟖReturn_type 7ꎨ탇웚쇹ꎩꎻ쫤죫2략믘횵캪쫽ퟖ1ꎨ탇웚튻ꎩ떽쫽ퟖ7ꎨ탇웚죕ꎩꎻ쫤죫3략믘횵캪쫽ퟖ0ꎨ탇웚튻ꎩ떽쫽ퟖ6ꎨ탇웚죕ꎩꆣ 奅䅒?릦쓜ꎺ략믘쒳죕웚뛔펦뗄쓪럝ꆣ 뇭듯쪽ꎺYEARꎨserial_numberꎩ 닎쫽몬틥ꎺ Serial_number 캪튻룶죕웚횵ꎬ웤훐냼몬튪닩헒쓪럝뗄죕웚ꆣ 쫽톧폫죽뷇몯쫽?䅂??릦쓜ꎺ략믘쫽ퟖ뗄뻸뛔횵ꆣ 뇭듯쪽ꎺABSꎨnumberꎩ 닎쫽몬틥ꎺ Number 탨튪볆쯣웤뻸뛔횵뗄쪵쫽ꆣ 䅃体?릦쓜ꎺ략믘쫽ퟖ뗄랴폠쿒횵ꆣ 뇭듯쪽ꎺACOSꎨnumberꎩ 닎쫽몬틥ꎺ Number 뷇뛈뗄폠쿒횵ꎬ뇘탫뷩폚-1떽1횮볤ꆣ 䅃体??릦쓜ꎺ략믘 number 닎쫽뗄랴쮫쟺폠쿒횵ꆣ 뇭듯쪽ꎺACOSHꎨnumberꎩ 닎쫽몬틥ꎺ Number 듳폚뗈폚1뗄쪵쫽ꆣ 䅓䥎?릦쓜ꎺ략믘닎쫽뗄랴헽쿒횵ꆣ 뇭듯쪽ꎺASINꎨnumberꎩ 닎쫽몬틥ꎺ Number 뷇뛈뗄헽쿒횵ꎬ뇘탫뷩폚-1떽1횮볤ꆣ 䅓䥎??릦쓜ꎺ략믘닎쫽뗄랴쮫쟺헽쿒횵ꆣ 10
뢽슼 뇭듯쪽ꎺASINHꎨnumberꎩ 닎쫽몬틥ꎺ Number 캪죎틢쪵쫽ꆣ 䅔䅎?릦쓜ꎺ략믘랴헽쟐횵ꆣ 뇭듯쪽ꎺATAN ꎨnumberꎩ 닎쫽몬틥ꎺ Number 뷇뛈뗄헽쟐횵ꆣ 䅔䅎??릦쓜ꎺ략믘룸뚨뗄 X 벰 Y ퟸ뇪횵뗄랴헽쟐횵ꆣ 뇭듯쪽ꎺATAN2ꎨx_numꎬy_numꎩ 닎쫽몬틥ꎺ X_num 뗣뗄Xퟸ뇪ꆣ Y_num 뗣뗄Yퟸ뇪ꆣ 䅔䅎??릦쓜ꎺ략믘닎쫽뗄랴쮫쟺헽쟐횵ꆣ 뇭듯쪽ꎺATANHꎨnumberꎩ 닎쫽몬틥ꎺ Number -1떽1횮볤뗄죎틢쪵쫽ꆣ 䍅䥌䥎??릦쓜ꎺ붫닎쫽Number쿲짏짡죫ꎨ퇘뻸뛔횵퓶듳뗄랽쿲ꎩ캪ퟮ뷓뷼뗄significance뗄놶쫽ꆣ 뇭듯쪽ꎺCEILINGꎨnumberꎬsignificanceꎩ 닎쫽몬틥ꎺ Number 튪쯄짡컥죫뗄쫽횵ꆣ Significance 쫇탨튪쯄짡컥죫뗄돋쫽ꆣ 䍏䵂䥎?릦쓜ꎺ볆쯣듓룸뚨쫽쒿뗄뛔쿳벯뫏훐쳡좡죴룉뛔쿳뗄ퟩ뫏쫽ꆣ 뇭듯쪽ꎺCOMBINꎨnumberꎬnumber_chosenꎩ 닎쫽몬틥ꎺ Number 캪뛔쿳뗄ퟜ쫽솿ꆣ Number_chosen 캪쎿튻ퟩ뫏훐뛔쿳뗄쫽솿ꆣ 䍏??릦쓜ꎺ략믘룸뚨뷇뛈뗄폠쿒횵ꆣ 뇭듯쪽ꎺCOSꎨnumberꎩ 닎쫽몬틥ꎺ 11
뷜돏1컄2 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 Number 캪탨튪쟳폠쿒뗄뷇뛈ꎬ틔뮡뛈뇭쪾ꆣ 䍏午?릦쓜ꎺ략믘쫽ퟖ뗄쮫쟺폠쿒횵ꆣ 뇭듯쪽ꎺCOSHꎨnumberꎩ 닎쫽몬틥ꎺ Number 뇭쪾튪쟳쮫쟺폠쿒뗄죎틢쪵쫽ꆣ 䑅䝒䕅??릦쓜ꎺ붫뮡뛈뮻캪뛈ꆣ 뇭듯쪽ꎺDEGREESꎨangleꎩ 닎쫽몬틥ꎺ Angle 듽뮻뗄뮡뛈뷇ꆣ 䕖䕎?릦쓜ꎺ략믘퇘뻸뛔횵퓶듳랽쿲좡헻뫳ퟮ뷓뷼뗄얼쫽ꆣ 뇭듯쪽ꎺEVENꎨnumberꎩ 닎쫽몬틥ꎺ Number 쫇붫뷸탐쯄짡컥죫뗄쫽횵ꆣ 䕘??릦쓜ꎺ략믘e뗄n듎쏝ꆣ 뇭듯쪽ꎺEXPꎨnumberꎩ 닎쫽몬틥ꎺ Number 캪뗗쫽e뗄횸쫽ꆣ 䙁䍔?릦쓜ꎺ략믘쫽뗄뷗돋ꆣ 뇭듯쪽ꎺFACTꎨnumberꎩ 닎쫽몬틥ꎺ Number 튪볆쯣웤뷗돋뗄럇뢺쫽ꆣ죧맻쫤죫뗄Number늻쫇헻쫽ꎬ퓲뷘캲좡헻ꆣ 䙌住??릦쓜ꎺ붫닎쫽Number퇘뻸뛔횵복킡뗄랽쿲ꎬ쿲쿂짡죫떽ퟮ뷓뷼뗄significance뗄놶쫽ꆣ 뇭듯쪽ꎺFLOORꎨnumberꎬsignificanceꎩ 닎쫽몬틥ꎺ Number 튪쯄짡컥죫뗄쫽횵ꆣ Significance 믹쫽ꆣ 䥎??릦쓜ꎺ붫쫽ퟖ쿲쿂짡죫떽ퟮ뷓뷼뗄헻쫽ꆣ 12
뢽슼 뇭듯쪽ꎺINTꎨnumberꎩ 닎쫽몬틥ꎺ Number 탨튪뷸탐쿲쿂짡죫좡헻뗄쪵쫽ꆣ 䱎?릦쓜ꎺ략믘튻룶쫽뗄ퟔ좻뛔쫽ꆣ 뇭듯쪽ꎺLNꎨnumberꎩ 닎쫽몬틥ꎺ Number 쫇폃폚볆쯣웤ퟔ좻뛔쫽뗄헽쪵쫽ꆣ 䱏??릦쓜ꎺ내쯹횸뚨뗄뗗쫽ꎬ략믘튻룶쫽뗄뛔쫽ꆣ 뇭듯쪽ꎺLOGꎨnumberꎬbaseꎩ 닎쫽몬틥ꎺ Number 캪폃폚볆쯣뛔쫽뗄헽쪵쫽ꆣ Base 캪뛔쫽뗄뗗쫽ꆣ죧맻쪡싔뗗쫽ꎬ볙뚨웤횵캪10ꆣ 䱏䜱??릦쓜ꎺ략믘틔10캪뗗뗄뛔쫽ꆣ 뇭듯쪽ꎺLOG10ꎨnumberꎩ 닎쫽몬틥ꎺ Number 폃폚뎣폃뛔쫽볆쯣뗄헽쪵쫽ꆣ 䵄䕔䕒??릦쓜ꎺ략믘튻룶쫽ퟩ뗄뻘헳탐쇐쪽뗄횵ꆣ 뇭듯쪽ꎺMDETERMꎨarrayꎩ 닎쫽몬틥ꎺ Array 탐쫽뫍쇐쫽쿠뗈뗄쫽횵쫽ퟩꆣ 䵉乖䕒卅?릦쓜ꎺ략믘쫽ퟩ뻘헳뗄쓦뻠헳ꆣ 뇭듯쪽ꎺMINVERSEꎨarrayꎩ 닎쫽몬틥ꎺ춬짏ꆣ 䵍啌??릦쓜ꎺ략믘솽쫽ퟩ뗄뻘헳돋믽ꆣ 뇭듯쪽ꎺMMULTꎨarray1ꎬarray2ꎩ 닎쫽몬틥ꎺ Array1ꎬ array2 쫇튪뷸탐뻘헳돋램퓋쯣뗄솽룶쫽ퟩꆣ 䵏??릦쓜ꎺ략믘솽쫽쿠돽뗄폠쫽ꆣ 13
뷜돏1컄4 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 뇭듯쪽ꎺMODꎨnumberꎬdivisorꎩ 닎쫽몬틥ꎺ Number 캪놻돽쫽ꆣ Divisor 캪돽쫽ꆣ 佄??릦쓜ꎺ략믘뛔횸뚨쫽횵뷸탐쿲짏짡죫뫳뗄웦쫽ꆣ 뇭듯쪽ꎺODDꎨnumberꎩ 닎쫽몬틥ꎺ Number 쫇붫뷸탐쯄짡컥죫뗄쫽횵ꆣ 偉?릦쓜ꎺ략믘쫽ퟖ ꎬ벴쫽톧뎣솿 piꎬ뺫좷떽킡쫽뗣뫳 14 캻ꆣ 뇭듯쪽ꎺPIꎨ ꎩ 偏坅??릦쓜ꎺ략믘룸뚨쫽ퟖ뗄돋쏝ꆣ 뇭듯쪽ꎺPOWERꎨnumberꎬpowerꎩ 닎쫽몬틥ꎺ Number 뗗쫽ꎬ뿉틔캪죎틢쪵쫽ꆣ Power 횸쫽ꎬ뗗쫽내룃횸쫽듎쏝돋랽ꆣ 偒佄啃??릦쓜ꎺ붫쯹폐틔닎쫽탎쪽룸돶뗄쫽ퟖ쿠돋ꎬ늢략믘돋믽횵ꆣ 뇭듯쪽ꎺPRODUCTꎨnumber1ꎬnumber2ꎬ...ꎩ 닎쫽몬틥ꎺ Number1ꎬ number2ꎬ ... 캪1떽30룶탨튪쿠돋뗄쫽ퟖ닎쫽ꆣ 剁䑉䅎??릦쓜ꎺ붫뷇뛈뮻캪뮡뛈ꆣ 뇭듯쪽ꎺRADIANSꎨangleꎩ 닎쫽몬틥ꎺ Angle 캪탨튪뮻돉뮡뛈뗄뷇뛈ꆣ 剁乄?릦쓜ꎺ략믘듳폚뗈폚 0 벰킡폚 1 뗄뻹퓈럖늼쯦믺쫽ꆣ 뇭듯쪽ꎺRANDꎨ ꎩ 剏䵁??릦쓜ꎺ붫낢삭늮쫽ퟖ뮻캪컄놾탎쪽뗄싞십쫽ퟖꆣ 뇭듯쪽ꎺROMANꎨnumberꎬformꎩ 닎쫽몬틥ꎺ 14
뢽슼 Number 캪탨튪뮻뗄낢삭늮쫽ퟖꆣ Form 캪튻쫽ퟖꎬ횸뚨쯹탨뗄싞십쫽ퟖ샠탍ꆣ 剏啎??릦쓜ꎺ략믘쒳룶쫽ퟖ내횸뚨캻쫽좡헻뫳뗄쫽ퟖꆣ 뇭듯쪽ꎺROUNDꎨnumberꎬnum_digitsꎩ 닎쫽몬틥ꎺ Number 탨튪뷸탐쯄짡컥죫뗄쫽ퟖꆣ Num_digits 횸뚨뗄캻쫽ꎬ내듋캻쫽뷸탐쯄짡컥죫ꆣ 剏啎䑄佗??릦쓜ꎺ뾿뷼쇣횵ꎬ쿲쿂ꎨ뻸뛔횵복킡뗄랽쿲ꎩ짡죫쫽ퟖꆣ 뇭듯쪽ꎺROUNDDOWNꎨnumberꎬnum_digitsꎩ 닎쫽몬틥ꎺ Number 캪탨튪쿲쿂짡죫뗄죎틢쪵쫽ꆣ Num_digits 쯄짡컥죫뫳뗄쫽ퟖ뗄캻쫽ꆣ 剏啎䑕??릦쓜ꎺ풶샫쇣횵ꎬ쿲짏짡죫쫽ퟖꆣ 뇭듯쪽ꎺROUNDUPꎨnumberꎬnum_digitsꎩ 닎쫽몬틥ꎺ Number 캪탨튪쿲짏짡죫뗄죎틢쪵쫽ꆣ Num_digits 쯄짡컥죫뫳뗄쫽ퟖ뗄캻쫽ꆣ 卉???릦쓜ꎺ략믘쫽ퟖ뗄럻뫅ꆣ떱쫽ퟖ캪헽쫽쪱략믘1ꎬ캪쇣쪱략믘0ꎬ캪뢺쫽쪱략믘-1ꆣ 뇭듯쪽ꎺSIGNꎨnumberꎩ Number 캪죎틢쪵쫽ꆣ 卉??릦쓜ꎺ략믘룸뚨뷇뛈뗄헽쿒횵ꆣ 뇭듯쪽ꎺSINꎨnumberꎩ 닎쫽몬틥ꎺ Number 캪탨튪쟳헽쿒뗄뷇뛈ꎬ틔뮡뛈뇭쪾ꆣ 卉么?릦쓜ꎺ략믘쒳튻쫽ퟖ뗄쮫쟺헽쿒횵ꆣ 뇭듯쪽ꎺSINHꎨnumberꎩ 닎쫽몬틥ꎺ Number 캪죎틢쪵쫽ꆣ 卑剔?릦쓜ꎺ략믘헽욽랽룹ꆣ 15
뷜돏1컄6 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 뇭듯쪽ꎺSQRTꎨnumberꎩ 닎쫽몬틥ꎺ Number 튪볆쯣욽랽룹뗄쫽ꆣ 单䉔佔䅌?릦쓜ꎺ략믘쇐뇭믲쫽뻝뿢훐뗄럖샠믣ퟜꆣ 뇭듯쪽ꎺSUBTOTALꎨfunction_numꎬ ref1ꎬ ref2ꎬ ...ꎩ 닎쫽몬틥ꎺ 캪1떽11ꎨ냼몬틾님횵ꎩ믲101떽111ꎨ뫶싔틾님횵ꎩ횮볤뗄쫽ퟖꎬ횸뚨쪹Function_num 폃뫎훖몯쫽퓚쇐뇭훐뷸탐럖샠믣ퟜ볆쯣ꆣ Ref1ꎬ ref2ꎬ … 캪튪뷸탐럖샠믣ퟜ볆쯣뗄1떽29룶쟸폲믲틽폃ꆣ 单??릦쓜ꎺ략믘쒳튻떥풪룱쟸폲훐쯹폐쫽ퟖ횮뫍ꆣ 뇭듯쪽ꎺSUMꎨnumber1ꎬnumber2ꎬ ...ꎩ 닎쫽몬틥ꎺ Number1ꎬ number2ꎬ … 캪1떽30룶탨튪쟳뫍뗄닎쫽ꆣ 单䵉??릦쓜ꎺ룹뻝횸뚨쳵볾뛔죴룉떥풪룱쟳뫍ꆣ 뇭듯쪽ꎺSUMIFꎨrangeꎬcriteriaꎬsum_rangeꎩ 닎쫽몬틥ꎺ Range 캪폃폚쳵볾에뛏뗄떥풪룱쟸폲ꆣ Criteria 캪좷뚨쓄킩떥풪룱붫놻쿠볓쟳뫍뗄쳵볾ꎬ웤탎쪽뿉틔캪쫽ퟖꆢ뇭듯쪽믲컄놾ꆣ Sum_range 쫇탨튪쟳뫍뗄쪵볊떥풪룱ꆣ 单䵐剏䑕䍔?릦쓜ꎺ퓚룸뚨뗄벸ퟩ쫽ퟩ훐ꎬ붫쫽ퟩ볤뛔펦뗄풪쯘쿠돋ꎬ늢략믘돋믽횮뫍ꆣ 뇭듯쪽ꎺSUMPRODUCTꎨarray1ꎬarray2ꎬ ...ꎩ 닎쫽몬틥ꎺ Array1ꎬ array2ꎬ ... 캪2떽30룶쫽ퟩꎬ웤쿠펦풪쯘탨튪뷸탐쿠돋늢쟳뫍ꆣ 单䵓??릦쓜ꎺ략믘닎쫽뗄욽랽뫍ꆣ 뇭듯쪽ꎺSUMSQꎨnumber1ꎬnumber2ꎬ ...ꎩ 닎쫽몬틥ꎺ Number1ꎬ number2ꎬ … 캪1떽30룶탨튪쟳욽랽뫍뗄닎쫽ꆣ 单䵘㉍夲?릦쓜ꎺ략믘솽쫽ퟩ훐뛔펦쫽횵뗄욽랽닮횮뫍ꆣ 뇭듯쪽ꎺSUMX2MY2ꎨarray_xꎬarray_yꎩ 닎쫽몬틥ꎺ 16
뢽슼 Array_x 캪뗚튻룶쫽ퟩ믲쫽횵쟸폲ꆣ Array_y 캪뗚뛾룶쫽ퟩ믲쫽횵쟸폲ꆣ 单䵘㉐夲?릦쓜ꎺ략믘솽쫽ퟩ훐뛔펦쫽횵뗄욽랽뫍횮뫍ꎬ욽랽뫍횮뫍ퟜ퓚춳볆볆쯣훐뺭뎣쪹폃ꆣ 뇭듯쪽ꎺSUMX2PY2ꎨarray_xꎬarray_yꎩ 닎쫽몬틥ꎺ춬짏ꆣ 单䵘䵙??릦쓜ꎺ략믘솽쫽ퟩ훐뛔펦쫽횵횮닮뗄욽랽뫍ꆣ 뇭듯쪽ꎺSUMXMY2ꎨarray_xꎬarray_yꎩ 닎쫽몬틥ꎺ춬짏ꆣ 呁??릦쓜ꎺ략믘룸뚨뷇뛈뗄헽쟐횵ꆣ 뇭듯쪽ꎺTANꎨnumberꎩ 닎쫽몬틥ꎺ Number 캪튪쟳헽쟐뗄뷇뛈ꎬ틔뮡뛈뇭쪾ꆣ 呁么?릦쓜ꎺ략믘쒳튻쫽ퟖ뗄쮫쟺헽쟐ꆣ 뇭듯쪽ꎺTANHꎨnumberꎩ 닎쫽몬틥ꎺ Number 캪죎틢쪵쫽ꆣ 呒啎??릦쓜ꎺ붫쫽ퟖ뗄킡쫽늿럖뷘좥ꎬ략믘헻쫽ꆣ 뇭듯쪽ꎺTRUNCꎨnumberꎬnum_digitsꎩ 닎쫽몬틥ꎺ Number 탨튪뷘캲좡헻뗄쫽ퟖꆣ Num_digits 폃폚횸뚨좡헻뺫뛈뗄쫽ퟖꆣNum_digits 뗄쒬죏횵캪0ꆣ 춳볆몯쫽?䅖䕄䕖?릦쓜ꎺ략믘튻ퟩ쫽뻝폫웤뻹횵뗄뻸뛔욫닮뗄욽뻹횵ꎬ폃폚움닢헢ퟩ쫽뻝뗄샫즢뛈ꆣ 뇭듯쪽ꎺAVEDEVꎨnumber1ꎬnumber2ꎬ...ꎩ 닎쫽몬틥ꎺ Number1ꎬ number2ꎬ폃폚볆쯣뻸뛔욫닮욽뻹횵뗄튻ퟩ닎쫽ꎬ닎쫽뗄룶쫽뿉틔폐1떽30룶 ... 17
뷜돏1컄8 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 䅖䕒䅇??릦쓜ꎺ략믘닎쫽뗄욽뻹횵ꎨ쯣쫵욽뻹횵ꎩꆣ 뇭듯쪽ꎺAVERAGEꎨnumber1ꎬnumber2ꎬ...ꎩ 닎쫽몬틥ꎺ Number1ꎬ number2ꎬ캪탨튪볆쯣욽뻹횵뗄1떽30룶닎쫽ꆣ ... 䅖䕒䅇䕁?릦쓜ꎺ볆쯣닎쫽쇐뇭훐쫽횵뗄욽뻹횵ꎨ쯣쫽욽뻹횵ꎩꆣ 쳘뗣ꎺ늻뷶쫽ퟖꎬ뛸쟒컄놾뫍싟벭횵ꎨ죧TRUE뫍FALSEꎩ튲붫볆쯣퓚쓚ꆣ 뇭듯쪽ꎺAVERAGEAꎨvalue1ꎬvalue2ꎬ...ꎩ 닎쫽몬틥ꎺ춬짏ꆣ 䉅呁䑉協?릦쓜ꎺ략믘Beta샛믽럖늼몯쫽ꆣ 뇭듯쪽ꎺBETADISTꎨxꎬalphaꎬbetaꎬAꎬBꎩ 닎쫽몬틥ꎺ X 폃살뷸탐몯쫽볆쯣뗄횵ꎬ뻓폚뿉톡탔짏쿂뷧ꎨA 뫍 Bꎩ횮볤ꆣ Alpha 럖늼닎쫽ꆣ Beta 럖늼닎쫽ꆣ A 쫽횵 x 쯹쫴쟸볤뗄뿉톡쿂뷧ꆣ B 쫽횵 x 쯹쫴쟸볤뗄뿉톡짏뷧ꆣ 䉅呁䥎??릦쓜ꎺ략믘횸뚨뗄beta럖늼샛믽럖늼몯쫽뗄랴몯쫽횵ꆣ 뇭듯쪽ꎺBETAINVꎨprobabilityꎬalphaꎬbetaꎬAꎬBꎩ 닎쫽몬틥ꎺ Probability Beta럖늼뗄룅싊횵ꆣ Alpha 럖늼닎쫽ꆣ Beta 럖늼닎쫽ꆣ A 쫽횵 x 쯹쫴쟸볤뗄뿉톡쿂뷧ꆣ B 쫽횵 x 쯹쫴쟸볤뗄뿉톡짏뷧ꆣ 䉉乏䵄䥓??릦쓜ꎺ략믘튻풪뛾쿮쪽럖늼뗄룅싊횵ꆣ 뇭듯쪽ꎺBINOMDISTꎨnumber_sꎬtrialsꎬprobability_sꎬcumulativeꎩ 닎쫽몬틥ꎺ Number_s 캪쫔퇩돉릦뗄듎쫽ꆣ Trials 캪뛀솢쫔퇩뗄듎쫽ꆣ Probability_s 캪쎿듎쫔퇩훐돉릦뗄룅싊ꆣ Cumulative 캪튻싟벭횵ꎬ폃폚좷뚨몯쫽뗄탎쪽ꆣ 18
뢽슼 䍈䥄䥓??릦쓜ꎺ략믘 ?2 럖늼뗄떥캲룅싊ꆣ 뇭듯쪽ꎺCHIDISTꎨxꎬdegrees_freedomꎩ 닎쫽몬틥ꎺ X 캪폃살볆쯣럖늼뗄쫽횵ꆣ Degrees_freedom ퟔ평뛈ꆣ 䍈䥉乖?릦쓜ꎺ략믘 ?2 럖늼떥캲룅싊뗄랴몯쫽횵ꆣ 뇭듯쪽ꎺCHIINVꎨprobabilityꎬdegrees_freedomꎩ 닎쫽몬틥ꎺ Probability 캪?2럖늼뗄떥캲룅싊ꆣ Degrees_freedom ퟔ평뛈ꆣ 䍈䥔䕓??릦쓜ꎺ략믘뛀솢탔볬퇩횵ꆣ략믘 ꎨ2cꎩ 럖늼뗄춳볆횵벰쿠펦뗄ퟔ평뛈ꆣ 뇭듯쪽ꎺCHITESTꎨactual_rangeꎬexpected_rangeꎩ 닎쫽몬틥ꎺ Actual_range 캪냼몬맛달횵뗄쫽뻝쟸폲ꎬ붫뫍웚췻횵ퟷ뇈뷏ꆣ Expected_range 캪냼몬탐쇐믣ퟜ뗄돋믽폫ퟜ볆횵횮뇈싊뗄쫽뻝쟸폲ꆣ 䍏乆䥄䕎䍅?릦쓜ꎺ략믘뿉릹붨ퟜ쳥욽뻹횵뗄훃탅쟸볤뗄횵ꆣ 뇭듯쪽ꎺCONFIDENCEꎨalphaꎬstandard_devꎬsizeꎩ 닎쫽몬틥ꎺ Alpha 쫇폃폚볆쯣훃탅뛈뗄쿔훸쮮욽닎쫽ꆣ Standard_dev 쫽뻝쟸폲뗄ퟜ쳥뇪ힼ욫닮ꎬ볙짨캪틑횪ꆣ Size 퇹놾죝솿 䍏剒䕌?릦쓜ꎺ략믘떥풪룱쟸폲array1뫍array2횮볤뗄쿠맘쾵쫽ꆣ 뇭듯쪽ꎺCORRELꎨarray1ꎬarray2ꎩ 닎쫽몬틥ꎺ Array1 뗚튻ퟩ쫽횵떥풪룱쟸폲ꆣ Array2 뗚뛾ퟩ쫽횵떥풪룱쟸폲ꆣ 䍏啎??릦쓜ꎺ략믘냼몬쫽ퟖ틔벰냼몬닎쫽쇐뇭훐뗄쫽ퟖ뗄떥풪룱뗄룶쫽ꆣ 뇭듯쪽ꎺCOUNTꎨvalue1ꎬvalue2ꎬ...ꎩ 닎쫽몬틥ꎺ Value1ꎬ value2ꎬ ... 캪냼몬믲틽폃룷훖샠탍쫽뻝뗄닎쫽ꎨ1 떽 30룶ꎩꆣ 19
뷜돏2컄0 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 䍏啎呁?릦쓜ꎺ략믘닎쫽쇐뇭훐럇뿕횵뗄떥풪룱룶쫽ꆣ 뇭듯쪽ꎺCOUNTAꎨvalue1ꎬvalue2ꎬ...ꎩ 닎쫽몬틥ꎺ Value1ꎬ value2ꎬ ... 캪쯹튪볆쯣뗄횵ꎬ닎쫽룶쫽캪1떽30룶ꆣ 䍏啎呂䱁之?릦쓜ꎺ볆쯣횸뚨떥풪룱쟸폲훐뿕냗떥풪룱뗄룶쫽ꆣ 뇭듯쪽ꎺCOUNTBLANKꎨrangeꎩ 닎쫽몬틥ꎺ Range 캪탨튪볆쯣웤훐뿕냗떥풪룱룶쫽뗄쟸폲ꆣ 䍏啎呉??릦쓜ꎺ볆쯣쟸폲훐싺ퟣ룸뚨쳵볾뗄떥풪룱뗄룶쫽ꆣ 뇭듯쪽ꎺCOUNTIFꎨrangeꎬcriteriaꎩ 닎쫽몬틥ꎺ Range 캪탨튪볆쯣웤훐싺ퟣ쳵볾뗄떥풪룱쫽쒿뗄떥풪룱쟸폲ꆣ Criteria 캪좷뚨쓄킩떥풪룱붫놻볆쯣퓚쓚뗄쳵볾ꎬ웤탎쪽뿉틔캪쫽ퟖꆢ뇭듯쪽믲컄놾ꆣ 䍏噁??릦쓜ꎺ략믘킭랽닮ꆣ 뇭듯쪽ꎺCOVARꎨarray1ꎬarray2ꎩ 닎쫽몬틥ꎺ Array1 뗚튻룶쯹몬쫽뻝캪헻쫽뗄떥풪룱쟸폲ꆣ Array2 뗚뛾룶쯹몬쫽뻝캪헻쫽뗄떥풪룱쟸폲ꆣ 䍒䥔䉉乏??릦쓜ꎺ략믘쪹샛믽뛾쿮쪽럖늼듳폚뗈폚쇙뷧횵뗄ퟮ킡횵ꆣ 뇭듯쪽ꎺCRITBINOMꎨtrialsꎬprobability_sꎬalphaꎩ 닎쫽몬틥ꎺ Trials 늮얬샻쫔퇩듎쫽ꆣ Probability_s 쎿듎쫔퇩훐돉릦뗄룅싊ꆣ Alpha 쇙뷧횵ꆣ 䑅噓??릦쓜ꎺ략믘쫽뻝뗣폫룷ퟔ퇹놾욽뻹횵욫닮뗄욽랽뫍ꆣ 뇭듯쪽ꎺDEVSQꎨnumber1ꎬnumber2ꎬ...ꎩ 닎쫽몬틥ꎺ Number1ꎬ number2ꎬ캪1떽30룶탨튪볆쯣욫닮욽랽뫍뗄닎쫽 ... 20
뢽슼 䕘偏乄䥓??릦쓜ꎺ략믘횸쫽럖늼ꆣ 뇭듯쪽ꎺEXPONDISTꎨxꎬlambdaꎬcumulativeꎩ 닎쫽몬틥ꎺ X 몯쫽뗄쫽횵ꆣ Lambda 닎쫽횵ꆣ Cumulative 캪튻싟벭횵ꎬ횸뚨횸쫽몯쫽뗄탎쪽ꆣ 䙄䥓??릦쓜ꎺ략믘F룅싊럖늼ꆣ 뇭듯쪽ꎺFDISTꎨxꎬdegrees_freedom1ꎬdegrees_freedom2ꎩ 닎쫽몬틥ꎺ X 닎쫽횵ꆣ Degrees_freedom1 럖ퟓퟔ평뛈ꆣ Degrees_freedom2 럖쒸ퟔ평뛈ꆣ 䙉乖?릦쓜ꎺ략믘 F 룅싊럖늼뗄랴몯쫽횵ꆣ 뇭듯쪽ꎺFINVꎨprobabilityꎬdegrees_freedom1ꎬdegrees_freedom2ꎩ 닎쫽몬틥ꎺ Probability 폫F샛믽럖늼쿠맘뗄룅싊횵ꆣ Degrees_freedom1 럖ퟓퟔ평뛈ꆣ Degrees_freedom2 럖쒸ퟔ평뛈ꆣ 䙉午䕒?릦쓜ꎺ략믘뗣x뗄 Fisher 뇤뮻ꆣ 뇭듯쪽ꎺFISHERꎨxꎩ 닎쫽몬틥ꎺ X 캪튻룶쫽ퟖꎬ퓚룃뗣뷸탐뇤뮻ꆣ 䙉午䕒䥎??릦쓜ꎺ략믘Fisher뇤뮻뗄랴몯쫽횵ꆣ 뇭듯쪽ꎺFISHERINVꎨyꎩ 닎쫽몬틥ꎺ Y 캪튻룶쫽횵ꎬ퓚룃뗣뷸탐랴뇤뮻ꆣ 䙏剅䍁協?릦쓜ꎺ룹뻝틑폐뗄쫽횵볆쯣믲풤닢캴살횵ꆣ 뇭듯쪽ꎺFORECASTꎨxꎬknown_y'sꎬknown_x'sꎩ 닎쫽몬틥ꎺ X 캪탨튪뷸탐풤닢뗄쫽뻝뗣ꆣ 21
뷜돏2컄2 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 Known_y's 캪틲뇤솿쫽ퟩ믲쫽뻝쟸폲 Known_x's 캪ퟔ뇤솿쫽ퟩ믲쫽뻝쟸폲ꆣ 䙒䕑啅?䍙?릦쓜ꎺ틔튻쇐뒹횱쫽ퟩ략믘쒳룶쟸폲훐쫽뻝뗄욵싊럖늼ꆣ 뇭듯쪽ꎺFREQUENCYꎨdata_arrayꎬbins_arrayꎩ 닎쫽몬틥ꎺ Data_array 캪튻쫽ퟩ믲뛔튻ퟩ쫽횵뗄틽폃ꎬ폃살볆쯣욵싊ꆣ Bins_array 캪볤룴뗄쫽ퟩ믲뛔볤룴뗄틽폃ꎬ룃볤룴폃폚뛔data_array훐뗄쫽횵뷸탐럖ퟩꆣ 䙔䕓??릦쓜ꎺ략믘 F 볬퇩뗄뷡맻ꆣ 뇭듯쪽ꎺFTESTꎨarray1ꎬarray2ꎩ 닎쫽몬틥ꎺ Array1 뗚튻룶쫽ퟩ믲쫽뻝쟸폲ꆣ Array2 뗚뛾룶쫽ퟩ믲쫽뻝쟸폲ꆣ 䝁䵍䅄䥓??릦쓜ꎺ략믘?싪럖늼ꆣ 뇭듯쪽ꎺGAMMADISTꎨxꎬalphaꎬbetaꎬcumulativeꎩ 닎쫽몬틥ꎺ X 캪폃살볆쯣?싪럖늼뗄쫽횵ꆣ Alpha 럖늼닎쫽ꆣ Beta 럖늼닎쫽ꆣ죧맻beta = 1ꎬ몯쫽GAMMADIST략믘뇪ힼ?싪럖늼ꆣ Cumulative 캪튻싟벭횵ꎬ뻶뚨몯쫽뗄탎쪽ꆣ 䝁䵍䅉乖?릦쓜ꎺ략믘?싪샛믽럖늼몯쫽뗄랴몯쫽ꆣ 뇭듯쪽ꎺGAMMAINVꎨprobabilityꎬalphaꎬbetaꎩ 닎쫽몬틥ꎺ Probability 캪?싪럖늼뗄룅싊횵ꆣ Alpha 럖늼닎쫽ꆣ Beta 럖늼닎쫽ꆣ 䝁䵍䅌??릦쓜ꎺ략믘?싪몯쫽뗄ퟔ좻뛔쫽ꎬGꎨxꎩꆣ 뇭듯쪽ꎺGAMMALNꎨxꎩ 닎쫽몬틥ꎺ X 캪탨튪볆쯣몯쫽GAMMALN뗄쫽횵ꆣ 䝅位䕁??릦쓜ꎺ략믘헽쫽쫽ퟩ믲쟸폲뗄벸뫎욽뻹횵ꆣ 22
뢽슼 뇭듯쪽ꎺGEOMEANꎨnumber1ꎬnumber2ꎬ...ꎩ 닎쫽몬틥ꎺ Number1ꎬ number2ꎬ ... 쫇폃폚볆쯣욽뻹쫽뗄1떽30룶닎쫽ꆣ 䝒佗呈?릦쓜ꎺ룹뻝쿖폐뗄쫽뻝풤닢횸쫽퓶뎤횵ꆣ 뇭듯쪽ꎺGROWTHꎨknown_y'sꎬknown_x'sꎬnew_x'sꎬconstꎩ 닎쫽몬틥ꎺ Known_y's 싺ퟣ횸쫽믘맩쓢뫏쟺쿟 y=b*m^x 뗄튻ퟩ틑횪뗄 y 횵ꆣ Known_x's 싺ퟣ횸쫽믘맩쓢뫏쟺쿟 y=b*m^x 뗄튻ퟩ틑횪뗄 x 횵ꎬ캪뿉톡닎쫽ꆣ New_x's 캪탨튪춨맽 GROWTH 몯쫽략믘뗄뛔펦 y 횵뗄튻ퟩ탂 x 횵ꆣ Const 캪튻싟벭횵ꎬ폃폚횸뚨쫇럱붫뎣쫽 b 잿훆짨캪 1ꆣ 䡁前䕁??릦쓜ꎺ략믘쫽뻝벯뫏뗄뗷뫍욽뻹횵ꆣ 뇭듯쪽ꎺHARMEANꎨnumber1ꎬnumber2ꎬ...ꎩ 닎쫽몬틥ꎺ Number1ꎬ number2ꎬ ... 쫇폃폚볆쯣욽뻹횵뗄1떽30룶닎쫽ꆣ 䡙假䕏䵄䥓??릦쓜ꎺ략믘뎬벸뫎럖늼ꆣ 뇭듯쪽ꎺHYPGEOMDISTꎨsample_sꎬnumber_sampleꎬpopulation_sꎬnumber_populationꎩ?닎쫽몬틥ꎺ Sample_s 퇹놾훐돉릦뗄듎쫽ꆣ Number_sample 퇹놾죝솿ꆣ Population_s 퇹놾ퟜ쳥훐돉릦뗄듎쫽ꆣ Number_population 퇹놾ퟜ쳥뗄죝솿ꆣ 䥎呅剃䕐??릦쓜ꎺ샻폃쿖폐뗄x횵폫y횵볆쯣횱쿟폫y훡뗄뷘뻠ꆣ 뇭듯쪽ꎺINTERCEPTꎨknown_y'sꎬknown_x'sꎩ?닎쫽몬틥ꎺ Known_y's 캪틲뇤뗄맛달횵믲쫽뻝벯뫏ꆣ Known_x's 캪ퟔ뇤뗄맛달횵믲쫽뻝벯뫏ꆣ 䭕剌?릦쓜ꎺ략믘쫽뻝벯뗄럥횵ꆣ 뇭듯쪽ꎺKURTꎨnumber1ꎬnumber2ꎬ...ꎩ?닎쫽몬틥ꎺ Number1ꎬ number2ꎬ ... 쫇폃폚볆쯣럥횵뗄1떽30룶닎쫽ꆣ 23
뷜돏2컄4 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 䱁?䝅?릦쓜ꎺ략믘쫽뻝벯훐뗚k룶ퟮ듳횵ꆣ 뇭듯쪽ꎺLARGEꎨarrayꎬkꎩ?닎쫽몬틥ꎺ Array 캪탨튪듓훐톡퓱뗚 K 캪략믘횵퓚쫽ퟩ믲쫽뻝떥풪룱쟸폲훐뗄캻훃ꎨ듓듳떽킡업ꎩꆣ 䱉久協?릦쓜ꎺ쪹폃ퟮ킡뛾돋램뛔틑횪쫽뻝뷸탐ퟮ병횱쿟쓢뫏ꎬ늢략믘쏨쫶듋횱쿟뗄쫽ퟩꆣ 뇭듯쪽ꎺLINESTꎨknown_y'sꎬknown_x'sꎬconstꎬstatsꎩ?닎쫽몬틥ꎺ Known_y's 쫇맘쾵뇭듯쪽y = mx + b훐틑횪뗄y횵벯뫏ꆣ Known_x's 쫇맘쾵뇭듯쪽y = mx + b훐틑횪뗄뿉톡x횵벯뫏ꆣ Const 캪튻싟벭횵ꎬ폃폚횸뚨쫇럱붫뎣솿b잿훆짨캪0ꆣ Stats 캪튻싟벭횵ꎬ횸뚨쫇럱략믘뢽볓믘맩춳볆횵ꆣ 䱏䝅協?릦쓜ꎺ볆쯣ퟮ럻뫏쫽뻝뗄횸쫽믘맩쓢뫏쟺쿟ꎬ늢략믘쏨쫶룃쟺쿟뗄쫽횵쫽ퟩꆣ 뇭듯쪽ꎺLOGESTꎨknown_y'sꎬknown_x'sꎬconstꎬstatsꎩ?닎쫽몬틥ꎺ Known_y's 싺ퟣ횸쫽믘맩쓢뫏쟺쿟y=b*m^x뗄튻ퟩ틑횪뗄y횵ꆣ Known_x's 싺ퟣ횸쫽믘맩쓢뫏쟺쿟y=b*m^x뗄튻ퟩ틑횪뗄x횵ꎬ캪뿉톡닎쫽ꆣ Const 캪튻싟벭횵ꎬ폃폚횸뚨쫇럱붫뎣쫽b잿훆짨캪1ꆣ Stats 캪튻싟벭횵ꎬ횸뚨쫇럱략믘뢽볓믘맩춳볆횵ꆣ 䵁??릦쓜ꎺ략믘튻ퟩ횵훐뗄ퟮ듳횵ꆣ 뇭듯쪽ꎺMAXꎨnumber1ꎬnumber2ꎬ...ꎩ?닎쫽몬틥ꎺ Number1ꎬ number2ꎬ ... 쫇튪듓훐헒돶ퟮ듳횵뗄1떽30룶쫽ퟖ닎쫽ꆣ 䵁塁?릦쓜ꎺ략믘닎쫽쇐뇭훐뗄ퟮ듳횵ꆣ컄놾횵뫍싟벭횵튲ퟷ캪쫽ퟖ살볆쯣ꆣ 뇭듯쪽ꎺMAXAꎨvalue1ꎬvalue2ꎬ...ꎩ?닎쫽몬틥ꎺ춬짏ꆣ 䵅䑉䅎?릦쓜ꎺ략믘룸뚨쫽횵벯뫏뗄훐횵ꆣ 뇭듯쪽ꎺMEDIANꎨnumber1ꎬnumber2ꎬ...ꎩ?닎쫽몬틥ꎺ Number1ꎬ number2ꎬ ... 튪볆쯣훐횵뗄1떽30룶쫽횵ꆣ 24
뢽슼 䵉??릦쓜ꎺ략믘튻ퟩ횵훐뗄ퟮ킡횵ꆣ 뇭듯쪽ꎺMINꎨnumber1ꎬnumber2ꎬ...ꎩ?닎쫽몬틥ꎺ Number1ꎬ number2ꎬ ... 쫇튪듓훐헒돶ퟮ킡횵뗄1떽30룶쫽ퟖ닎쫽ꆣ 䵉乁?릦쓜ꎺ략믘닎쫽쇐뇭훐뗄ퟮ킡횵ꆣ컄놾횵뫍싟벭횵튲ퟷ캪쫽ퟖ살볆쯣ꆣ 뇭듯쪽ꎺMINAꎨvalue1ꎬvalue2ꎬ...ꎩ?닎쫽몬틥ꎺ춬짏ꆣ 䵏䑅?릦쓜ꎺ략믘퓚쒳튻쫽ퟩ믲쫽뻝쟸폲훐돶쿖욵싊ퟮ뛠뗄쫽횵ꆣ 뇭듯쪽ꎺMODEꎨnumber1ꎬnumber2ꎬ...ꎩ?닎쫽몬틥ꎺ Number1ꎬ number2ꎬ ... 쫇폃폚훚쫽볆쯣뗄1떽30룶닎쫽 乏前䑉協?릦쓜ꎺ략믘횸뚨욽뻹횵뫍뇪ힼ욫닮뗄헽첬럖늼몯쫽ꆣ 뇭듯쪽ꎺNORMDISTꎨxꎬmeanꎬstandard_devꎬcumulativeꎩ?닎쫽몬틥ꎺ X 캪탨튪볆쯣웤럖늼뗄쫽횵ꆣ Mean 럖늼뗄쯣쫵욽뻹횵ꆣ Standard_dev 럖늼뗄뇪ힼ욫닮ꆣ Cumulative 캪튻싟벭횵ꎬ횸쏷몯쫽뗄탎쪽ꆣ 乏前䥎??릦쓜ꎺ략믘횸뚨욽뻹횵뫍뇪ힼ욫닮뗄헽첬샛믽럖늼몯쫽뗄랴몯쫽ꆣ 뇭듯쪽ꎺNORMINVꎨprobabilityꎬmeanꎬstandard_devꎩ?닎쫽몬틥ꎺ Probability 헽첬럖늼뗄룅싊횵ꆣ Mean 럖늼뗄쯣쫵욽뻹횵ꆣ Standard_dev 럖늼뗄뇪ힼ욫닮ꆣ 乏前卄䥓??릦쓜ꎺ략믘뇪ힼ헽첬샛믽럖늼몯쫽ꎬ룃럖늼뗄욽뻹횵캪0ꎬ뇪ힼ욫닮캪1ꆣ 뇭듯쪽ꎺNORMSDISTꎨzꎩ?닎쫽몬틥ꎺ Z 캪탨튪볆쯣웤럖늼뗄쫽횵ꆣ 乏前卉乖?릦쓜ꎺ략믘뇪ힼ헽첬샛믽럖늼몯쫽뗄랴몯쫽ꆣ 25
뷜돏2컄6 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 뇭듯쪽ꎺNORMSINVꎨprobabilityꎩ?닎쫽몬틥ꎺ Probability 헽첬럖늼뗄룅싊횵ꆣ 偅䅒协??릦쓜ꎺ략믘 Pearsonꎨ욤뛻짺ꎩ돋믽뻘쿠맘쾵쫽 rꆣ 뇭듯쪽ꎺPEARSONꎨarray1ꎬarray2ꎩ?닎쫽몬틥ꎺ Array1 캪ퟔ뇤솿벯뫏ꆣ Array2 캪틲뇤솿벯뫏ꆣ 偅剃䕎呉䱅?릦쓜ꎺ략믘쟸폲훐쫽횵뗄뗚K룶냙럖뗣뗄횵ꆣ 뇭듯쪽ꎺPERCENTILEꎨarrayꎬkꎩ?닎쫽몬틥ꎺ Array 캪뚨틥쿠뛔캻훃뗄쫽ퟩ믲쫽뻝쟸폲ꆣ K 0떽1횮볤뗄냙럖뗣횵ꎬ냼몬0뫍1ꆣ 偅剃䕎剁之?릦쓜ꎺ략믘쳘뚨쫽횵퓚튻룶쫽뻝벯훐뗄냙럖뇈업캻ꆣ 뇭듯쪽ꎺPERCENTRANKꎨarrayꎬxꎬsignificanceꎩ?닎쫽몬틥ꎺ Array 캪뚨틥쿠뛔캻훃뗄쫽ퟩ믲쫽ퟖ쟸폲ꆣ X 캪쫽ퟩ훐탨튪뗃떽웤업캻뗄횵ꆣ Significance 캪뿉톡쿮ꎬ뇭쪾략믘뗄냙럖쫽횵뗄폐킧캻쫽ꆣ 偅前啔?릦쓜ꎺ략믘듓룸뚨쫽쒿뗄뛔쿳벯뫏훐톡좡뗄죴룉뛔쿳뗄업쇐쫽ꆣ 뇭듯쪽ꎺPERMUTꎨnumberꎬnumber_chosenꎩ?닎쫽몬틥ꎺ Number 뇭쪾뛔쿳룶쫽뗄헻쫽ꆣ Number_chosen 뇭쪾쎿룶업쇐훐뛔쿳룶쫽뗄헻쫽ꆣ 偏䥓协??릦쓜ꎺ략믘늴쯉럖늼ꆣ 뇭듯쪽ꎺPOISSONꎨxꎬmeanꎬcumulativeꎩ?닎쫽몬틥ꎺ X 쫂볾쫽ꆣ Mean 웚췻횵ꆣ Cumulative 캪튻싟벭횵ꎬ좷뚨쯹략믘뗄룅싊럖늼탎쪽ꆣ 26
뢽슼 偒佂?릦쓜ꎺ략믘쟸폲훐뗄쫽횵실퓚횸뚨쟸볤쓚뗄룅싊ꆣ 뇭듯쪽ꎺPROBꎨx_rangeꎬprob_rangeꎬlower_limitꎬupper_limitꎩ?닎쫽몬틥ꎺ X_range 뻟폐룷ퟔ쿠펦룅싊횵뗄 x 쫽횵쟸폲ꆣ Prob_range 폫 x_range 훐뗄횵쿠뛔펦뗄튻ퟩ룅싊횵ꆣ Lower_limit 폃폚볆쯣룅싊뗄쫽횵쿂뷧ꆣ Upper_limit 폃폚볆쯣룅싊뗄뿉톡쫽횵짏뷧ꆣ 兕䅒呉䱅?릦쓜ꎺ략믘쫽뻝벯뗄쯄럖캻쫽ꆣ 뇭듯쪽ꎺQUARTILEꎨarrayꎬquartꎩ?닎쫽몬틥ꎺ Array 캪탨튪쟳뗃쯄럖캻쫽횵뗄쫽ퟩ믲쫽ퟖ탍떥풪룱쟸폲ꆣ 뻶뚨략믘쓄튻룶쯄럖캻횵ꆣ쫤죫0뇭쪾ퟮ킡횵ꎻ쫤죫1뇭쪾뗚튻룶쯄럖캻쫽ꎨ뗚 Quart 25 룶냙럖뗣횵ꎩꎻ쫤죫2뇭쪾훐럖캻쫽ꎨ뗚 50 룶냙럖뗣횵ꎩꎻ쫤죫3뇭쪾뗚죽룶쯄럖캻쫽ꎨ뗚 75 룶냙럖뗣횵ꎩꎻ쫤죫4뇭쪾ퟮ듳횵ꆣ 剁之?릦쓜ꎺ략믘튻룶쫽ퟖ퓚쫽ퟖ쇐뇭훐뗄업캻ꆣ 뇭듯쪽ꎺRANKꎨnumberꎬrefꎬorderꎩ?닎쫽몬틥ꎺ Number 캪탨튪헒떽업캻뗄쫽ퟖꆣ Ref 캪쫽ퟖ쇐뇭쫽ퟩ믲뛔쫽ퟖ쇐뇭뗄틽폃ꆣ Order 캪튻쫽ퟖꎬ횸쏷업캻뗄랽쪽ꆣ 剓??릦쓜ꎺ략믘룹뻝known_y's뫍known_x's훐쫽뻝뗣볆쯣Pearson돋믽뻘쿠맘쾵쫽뗄욽랽ꆣ 뇭듯쪽ꎺRSQꎨknown_y'sꎬknown_x'sꎩ?닎쫽몬틥ꎺ Known_y's 캪쫽ퟩ믲쫽뻝뗣쟸폲ꆣ Known_x's 캪쫽ퟩ믲쫽뻝뗣쟸폲ꆣ 卋䕗?릦쓜ꎺ략믘럖늼뗄욫킱뛈ꆣ 뇭듯쪽ꎺSKEWꎨnumber1ꎬnumber2ꎬ...ꎩ?닎쫽몬틥ꎺ Number1ꎬ number2ꎬ ... 캪탨튪볆쯣욫킱뛈뗄1떽30룶닎쫽ꆣ 卌佐??릦쓜ꎺ략믘룹뻝known_y's뫍known_x's훐뗄쫽뻝뗣쓢뫏뗄쿟탔믘맩횱쿟뗄킱싊ꆣ 뇭듯쪽ꎺSLOPEꎨknown_y'sꎬknown_x'sꎩ?27
뷜돏2컄8 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 닎쫽몬틥ꎺ Known_y's 캪쫽ퟖ탍틲뇤솿쫽뻝뗣쫽ퟩ믲떥풪룱쟸폲 Known_x's 캪ퟔ뇤솿쫽뻝뗣벯뫏ꆣ 卍䅌??릦쓜ꎺ략믘쫽뻝벯훐뗚k룶ퟮ킡횵ꆣ 뇭듯쪽ꎺSMALLꎨarrayꎬkꎩ?닎쫽몬틥ꎺ Array 캪탨튪헒떽뗚 k 룶ퟮ킡횵뗄쫽ퟩ믲쫽ퟖ탍쫽뻝쟸폲ꆣ K 캪략믘뗄쫽뻝퓚쫽ퟩ믲쫽뻝쟸폲샯뗄캻훃ꎨ듓킡떽듳ꎩꆣ 協䑅??릦쓜ꎺ맀쯣퇹놾뗄뇪ힼ욫닮ꆣ 뇭듯쪽ꎺSTDEVꎨnumber1ꎬnumber2ꎬ...ꎩ?닎쫽몬틥ꎺ Number1ꎬ number2ꎬ ... 캪뛔펦폚ퟜ쳥퇹놾뗄1떽30룶닎쫽ꆣ 協䑅噁?릦쓜ꎺ맀쯣믹폚룸뚨퇹놾뗄뇪ힼ욫닮ꆣ컄놾횵뫍싟벭횵튲붫볆쯣퓚쓚ꆣ 뇭듯쪽ꎺSTDEVAꎨvalue1ꎬvalue2ꎬ...ꎩ?닎쫽몬틥ꎺ춬짏ꆣ 協䑅噐?릦쓜ꎺ략믘틔닎쫽탎쪽룸돶뗄헻룶퇹놾ퟜ쳥뗄뇪ힼ욫닮ꆣ 뇭듯쪽ꎺSTDEVPꎨnumber1ꎬnumber2ꎬ...ꎩ?닎쫽몬틥ꎺ Number1ꎬ number2ꎬ ... 캪뛔펦폚퇹놾ퟜ쳥뗄1떽30룶닎쫽ꆣ 協䑅噐??릦쓜ꎺ략믘틔닎쫽탎쪽룸돶뗄헻룶퇹놾ퟜ쳥뗄뇪ힼ욫닮ꎬ냼몬컄놾뫍싟벭횵ꆣ 뇭듯쪽ꎺSTDEVPAꎨvalue1ꎬvalue2ꎬ...ꎩ?닎쫽몬틥ꎺ춬짏ꆣ 呄䥓??릦쓜ꎺ략믘t럖늼뗄냙럖뗣ꎨ룅싊ꎩꆣ 뇭듯쪽ꎺTDISTꎨxꎬdegrees_freedomꎬtailsꎩ?닎쫽몬틥ꎺ X 캪탨튪볆쯣럖늼뗄쫽ퟖꆣ Degrees_freedom 캪뇭쪾ퟔ평뛈뗄헻쫽ꆣ Tails 횸쏷략믘뗄럖늼몯쫽쫇떥캲럖늼뮹쫇쮫캲럖늼ꆣ 呉乖?릦쓜ꎺ략믘ퟷ캪룅싊뫍ퟔ평뛈몯쫽뗄t럖늼뗄t횵ꆣ 28
뢽슼 뇭듯쪽ꎺTINVꎨprobabilityꎬdegrees_freedomꎩ?닎쫽몬틥ꎺ Probability 캪뛔펦폚쮫캲톧짺t럖늼뗄룅싊ꆣ Degrees_freedom 캪럖늼뗄ퟔ평뛈ꆣ 呒䕎??릦쓜ꎺ략믘튻쳵쿟탔믘맩쓢뫏쿟뗄횵ꆣ 뇭듯쪽ꎺTRENDꎨknown_y'sꎬknown_x'sꎬnew_x'sꎬconstꎩ?닎쫽몬틥ꎺ Known_y's 쫇맘쾵뇭듯쪽y = mx + b훐틑횪뗄y횵벯뫏ꆣ Known_x's 쫇맘쾵뇭듯쪽y = mx + b훐틑횪뗄뿉톡x횵벯뫏ꆣ New_x's 캪탨튪몯쫽TREND략믘뛔펦y횵뗄탂x횵ꆣ Const 캪튻싟벭횵ꎬ폃폚횸뚨쫇럱붫뎣솿b잿훆짨캪0ꆣ 呒䥍䵅䅎?릦쓜ꎺ략믘쫽뻝벯뗄쓚늿욽뻹횵ꆣ 뇭듯쪽ꎺTRIMMEANꎨarrayꎬpercentꎩ?닎쫽몬틥ꎺ Array 캪탨튪뷸탐헻샭늢쟳욽뻹횵뗄쫽ퟩ믲쫽횵쟸폲ꆣ Percent 캪볆쯣쪱쯹튪돽좥뗄쫽뻝뗣뗄뇈샽ꆣ 呔䕓??릦쓜ꎺ략믘t볬퇩쿠맘뗄룅싊ꆣ 뇭듯쪽ꎺTTESTꎨarray1ꎬarray2ꎬtailsꎬtypeꎩ?닎쫽몬틥ꎺ Array1 캪뗚튻룶쫽뻝벯ꆣ Array2 캪뗚뛾룶쫽뻝벯ꆣ Tails 횸쪾럖늼쟺쿟뗄캲쫽ꆣ Type 캪 t 볬퇩뗄샠탍ꆣ 噁??릦쓜ꎺ볆쯣믹폚룸뚨퇹놾뗄랽닮ꆣ 뇭듯쪽ꎺVARꎨnumber1ꎬnumber2ꎬ...ꎩ?닎쫽몬틥ꎺ Number1ꎬ number2ꎬ ... 캪뛔펦폚ퟜ쳥퇹놾뗄1떽30룶닎쫽ꆣ 噁剁?릦쓜ꎺ볆쯣믹폚룸뚨퇹놾뗄랽닮ꆣ늻뷶쫽ퟖꎬ컄놾횵뫍싟벭횵튲붫볆쯣퓚쓚ꆣ 뇭듯쪽ꎺVARAꎨvalue1ꎬvalue2ꎬ...ꎩ?닎쫽몬틥ꎺ춬짏ꆣ 29
뷜돏3컄0 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 噁剐?릦쓜ꎺ볆쯣믹폚헻룶퇹놾ퟜ쳥뗄랽닮ꆣ 뇭듯쪽ꎺVARPꎨnumber1ꎬnumber2ꎬ...ꎩ?닎쫽몬틥ꎺ춬짏ꆣ 噁剐??릦쓜ꎺ볆쯣믹폚헻룶퇹놾ퟜ쳥뗄랽닮ꆣ늻뷶쫽ퟖꎬ컄놾횵뫍싟벭횵튲붫볆쯣퓚쓚ꆣ 뇭듯쪽ꎺVARPAꎨnumber1ꎬnumber2ꎬ...ꎩ?닎쫽몬틥ꎺ춬짏ꆣ 坅䥂啌??릦쓜ꎺ략믘캤늮럖늼ꆣ 뇭듯쪽ꎺWEIBULLꎨxꎬalphaꎬbetaꎬcumulativeꎩ?닎쫽몬틥ꎺ X 닎쫽횵ꆣ Alpha 럖늼닎쫽ꆣ Beta 럖늼닎쫽ꆣ Cumulative 횸쏷몯쫽뗄탎쪽ꆣ 婔䕓??릦쓜ꎺ략믘z볬퇩뗄떥캲룅싊횵ꆣ 뇭듯쪽ꎺZTESTꎨarrayꎬµ0ꎬsigmaꎩ?닎쫽몬틥ꎺ Array 캪폃살볬퇩 µ0 뗄쫽ퟩ믲쫽뻝쟸폲ꆣ µ0 캪놻볬퇩뗄횵ꆣ Sigma 캪퇹놾ퟜ쳥ꎨ틑횪ꎩ뗄뇪ힼ욫닮ꎬ죧맻쪡싔ꎬ퓲쪹폃퇹놾뇪ힼ욫닮ꆣ 닩헒폫틽폃몯쫽?䅄䑒䕓??릦쓜ꎺ내헕룸뚨뗄탐뫅뫍쇐뇪ꎬ붨솢컄놾샠탍뗄떥풪룱뗘횷ꆣ 뇭듯쪽ꎺADDRESSꎨrow_numꎬcolumn_numꎬabs_numꎬa1ꎬsheet_textꎩ?닎쫽몬틥ꎺ Row_num 퓚떥풪룱틽폃훐쪹폃뗄탐뫅ꆣ Column_num 퓚떥풪룱틽폃훐쪹폃뗄쇐뇪ꆣ Abs_num 횸뚨략믘뗄틽폃샠탍ꆣ A1 폃틔횸뚨 A1 믲 R1C1 틽폃퇹쪽뗄싟벭횵ꆣ Sheet_text 캪튻컄놾ꎬ횸뚨ퟷ캪췢늿틽폃뗄릤ퟷ뇭뗄쏻돆ꆣ 30
뢽슼 䅒䕁??릦쓜ꎺ략믘틽폃훐냼몬뗄쟸폲룶쫽ꆣ 뇭듯쪽ꎺAREASꎨreferenceꎩ?닎쫽몬틥ꎺ Reference 뛔쒳룶떥풪룱믲떥풪룱쟸폲뗄틽폃ꎬ튲뿉틔틽폃뛠룶쟸폲ꆣ 䍈住卅?릦쓜ꎺ뿉틔쪹폃index_num략믘쫽횵닎쫽쇐뇭훐뗄쫽횵ꆣ 뇭듯쪽ꎺCHOOSEꎨindex_numꎬvalue1ꎬvalue2ꎬ...ꎩ?닎쫽몬틥ꎺ Index_num 폃틔횸쏷듽톡닎쫽탲뫅뗄닎쫽횵ꆣ Value1ꎬvalue2ꎬ... 캪1떽29룶쫽횵닎쫽ꆣ 䍏䱕䵎?릦쓜ꎺ략믘룸뚨틽폃뗄쇐뇪ꆣ 뇭듯쪽ꎺCOLUMNꎨreferenceꎩ?닎쫽몬틥ꎺ Reference 캪탨튪뗃떽웤쇐뇪뗄떥풪룱믲떥풪룱쟸폲ꆣ 䍏䱕䵎??릦쓜ꎺ략믘쫽ퟩ믲틽폃뗄쇐쫽ꆣ 뇭듯쪽ꎺCOLUMNSꎨarrayꎩ?닎쫽몬틥ꎺ Array 캪탨튪뗃떽웤쇐쫽뗄쫽ퟩ믲쫽ퟩ릫쪽ꎬ믲뛔떥풪룱쟸폲뗄틽폃ꆣ 䡌住䭕??릦쓜ꎺ퓚뇭룱믲쫽횵쫽ퟩ뗄쫗탐닩헒횸뚨뗄쫽횵ꎬ늢평듋략믘뇭룱믲쫽ퟩ떱잰쇐훐횸뚨탐뒦뗄쫽횵ꆣ 뇭듯쪽ꎺHLOOKUPꎨlookup_valueꎬtable_arrayꎬrow_index_numꎬrange_lookupꎩ?닎쫽몬틥ꎺ Lookup_value 캪탨튪퓚쫽뻝뇭뗚튻탐훐뷸탐닩헒뗄쫽횵ꆣ Table_array 캪탨튪퓚웤훐닩헒쫽뻝뗄쫽뻝뇭ꆣ Row_index_num 캪 table_array 훐듽략믘뗄욥엤횵뗄탐탲뫅ꆣ Range_lookup 캪튻싟벭횵ꎬ횸쏷몯쫽 HLOOKUP 닩헒쪱쫇뺫좷욥엤ꎬ뮹쫇뷼쯆욥엤ꆣ 䡙偅剌䥎??릦쓜ꎺ뒴붨튻룶뿬뷝랽쪽ꎨ쳸ꎩꎬ폃틔듲뾪듦뒢퓚췸싧럾컱웷믲Internet훐뗄컄볾ꆣ 뇭듯쪽ꎺHYPERLINKꎨlink_locationꎬ friendly_nameꎩ?닎쫽몬틥ꎺ Link_location 캪컄떵뗄슷뺶뫍컄볾쏻ꎬ듋컄떵뿉틔ퟷ캪컄놾듲뾪ꆣ Friendly_name 캪떥풪룱훐쿔쪾뗄쳸컄놾횵믲쫽ퟖ횵ꆣ 31
뷜돏3컄2 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 ?乄䕘ꎨ쫽ퟩꎩ?릦쓜ꎺ략믘쇐뇭믲쫽ퟩ훐뗄풪쯘횵ꎬ듋풪쯘평탐탲뫅뫍쇐탲뫅뗄쯷틽횵룸뚨ꆣ 뇭듯쪽ꎺINDEXꎨarrayꎬrow_numꎬcolumn_numꎩ?닎쫽몬틥ꎺ Array 캪떥풪룱쟸폲믲쫽ퟩ뎣솿ꆣ Row_num 쫽ퟩ훐쒳탐뗄탐탲뫅ꎬ몯쫽듓룃탐략믘쫽횵ꆣ Column_num 쫽ퟩ훐쒳쇐뗄쇐탲뫅ꎬ몯쫽듓룃쇐략믘쫽횵ꆣ 䥎䑅?ꎨ틽폃ꎩ?릦쓜ꎺ략믘횸뚨뗄탐폫쇐붻닦뒦뗄떥풪룱틽폃ꆣ 뇭듯쪽ꎺINDEXꎨreferenceꎬrow_numꎬcolumn_numꎬarea_numꎩ?닎쫽몬틥ꎺ Reference 뛔튻룶믲뛠룶떥풪룱쟸폲뗄틽폃ꆣ Row_num 틽폃훐쒳탐뗄탐탲뫅ꎬ몯쫽듓룃탐략믘튻룶틽폃ꆣ Column_num 틽폃훐쒳쇐뗄쇐탲뫅ꎬ몯쫽듓룃쇐략믘튻룶틽폃ꆣ Area_num 톡퓱틽폃훐뗄튻룶쟸폲ꎬ늢략믘룃쟸폲훐row_num뫍column_num뗄붻닦쟸폲ꆣ 䥎䑉剅䍔?릦쓜ꎺ략믘평컄놾ퟖ럻뒮횸뚨뗄틽폃ꆣ 뇭듯쪽ꎺINDIRECTꎨref_textꎬa1ꎩ?닎쫽몬틥ꎺ Ref_text 캪뛔떥풪룱뗄틽폃ꆣ A1 캪튻싟벭횵ꎬ횸쏷냼몬퓚떥풪룱ref_text 훐뗄틽폃뗄샠탍ꆣ 䱏佋啐ꎨ쿲솿ꎩ?릦쓜ꎺ퓚떥탐쟸폲믲떥쇐쟸폲ꎨ쿲솿ꎩ훐닩헒쫽횵ꎬ좻뫳략믘뗚뛾룶떥탐쟸폲믲떥쇐쟸폲훐쿠춬캻훃뗄쫽횵ꆣ 뇭듯쪽ꎺLOOKUPꎨlookup_valueꎬlookup_vectorꎬresult_vectorꎩ?닎쫽몬틥ꎺ Lookup_value 캪몯쫽LOOKUP 퓚뗚튻룶쿲솿훐쯹튪닩헒뗄쫽횵ꆣ Lookup_vector 캪횻냼몬튻탐믲튻쇐뗄쟸폲ꆣ Result_vector 횻냼몬튻탐믲튻쇐뗄쟸폲ꎬ웤듳킡뇘탫폫lookup_vector쿠춬ꆣ 䱏佋啐ꎨ쫽ퟩꎩ?릦쓜ꎺ퓚쫽ퟩ뗄뗚튻탐믲뗚튻쇐훐닩헒횸뚨쫽횵ꎬ좻뫳략믘ퟮ뫳튻탐믲ퟮ뫳튻쇐훐쿠춬캻훃뒦뗄쫽횵ꆣ 뇭듯쪽ꎺLOOKUPꎨlookup_valueꎬarrayꎩ?닎쫽몬틥ꎺ Lookup_value 캪몯쫽LOOKUP퓚쫽ퟩ훐쯹튪닩헒뗄쫽횵ꆣ Array캪냼몬컄놾ꆢ쫽ퟖ믲싟벭횵뗄떥풪룱쟸폲ꎬ쯼뗄횵폃폚폫 lookup_value 뷸탐뇈뷏ꆣ 32
뢽슼 䵁呃??릦쓜ꎺ략믘퓚횸뚨랽쪽쿂폫횸뚨쫽횵욥엤뗄쫽ퟩ훐풪쯘뗄쿠펦캻훃ꆣ 뇭듯쪽ꎺMATCHꎨlookup_valueꎬlookup_arrayꎬmatch_typeꎩ?닎쫽몬틥ꎺ Lookup_value 캪탨튪퓚쫽뻝뇭훐닩헒뗄쫽횵ꆣ Lookup_array 뿉쓜냼몬쯹튪닩헒뗄쫽횵뗄솬탸떥풪룱쟸폲ꆣ Match_type 캪쫽ퟖ-1ꆢ0 믲 1ꆣ 但䙓䕔?릦쓜ꎺ틔횸뚨뗄틽폃캪닎헕쾵ꎬ춨맽룸뚨욫틆솿뗃떽탂뗄틽폃ꆣ 뇭듯쪽ꎺOFFSETꎨreferenceꎬrowsꎬcolsꎬheightꎬwidthꎩ?닎쫽몬틥ꎺ Reference ퟷ캪욫틆솿닎헕쾵뗄틽폃쟸폲ꆣ Rows 쿠뛔폚욫틆솿닎헕쾵뗄ퟳ짏뷇떥풪룱ꎬ짏ꎨ쿂ꎩ욫틆뗄탐쫽ꆣ Cols 쿠뛔폚욫틆솿닎헕쾵뗄ퟳ짏뷇떥풪룱ꎬퟳꎨ폒ꎩ욫틆뗄쇐쫽ꆣ Height 룟뛈ꎬ벴쯹튪략믘뗄틽폃쟸폲뗄탐쫽ꆣ Width 뿭뛈ꎬ벴쯹튪략믘뗄틽폃쟸폲뗄쇐쫽ꆣ 剏??릦쓜ꎺ략믘틽폃뗄탐뫅ꆣ 뇭듯쪽ꎺROWꎨreferenceꎩ?닎쫽몬틥ꎺ Reference 캪탨튪뗃떽웤탐뫅뗄떥풪룱믲떥풪룱쟸폲ꆣ 剏坓?릦쓜ꎺ략믘틽폃믲쫽ퟩ뗄탐쫽ꆣ 뇭듯쪽ꎺROWSꎨarrayꎩ?닎쫽몬틥ꎺ Array 캪탨튪뗃떽웤탐쫽뗄쫽ퟩꆢ쫽ퟩ릫쪽믲뛔떥풪룱쟸폲뗄틽폃ꆣ 呒䅎卐体??릦쓜ꎺ략믘훃떥풪룱쟸폲ꎬ벴붫튻탐떥풪룱쟸폲훃돉튻쇐떥풪룱쟸폲ꎬ랴횮틠좻ꆣ 뇭듯쪽ꎺTRANSPOSEꎨarrayꎩ?닎쫽몬틥ꎺ Array 캪탨튪뷸탐훃뗄쫽ퟩ믲릤ퟷ뇭훐뗄떥풪룱쟸폲ꆣ 噌住䭕??릦쓜ꎺ퓚뇭룱믲쫽횵쫽ퟩ뗄쫗쇐닩헒횸뚨뗄쫽횵ꎬ늢평듋략믘뇭룱믲쫽ퟩ떱잰탐훐횸뚨쇐뒦뗄쫽횵ꆣ 뇭듯쪽ꎺVLOOKUPꎨlookup_valueꎬtable_arrayꎬcol_index_numꎬrange_lookupꎩ?닎쫽몬틥ꎺ Lookup_value 캪탨튪퓚쫽ퟩ뗚튻쇐훐닩헒뗄쫽횵ꆣ 33
뷜돏3컄4 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 Table_array 캪탨튪퓚웤훐닩헒쫽뻝뗄쫽뻝뇭ꆣ Col_index_num 캪table_array훐듽략믘뗄욥엤횵뗄쇐탲뫅ꆣ Range_lookup 캪튻싟벭횵ꎬ횸쏷몯쫽VLOOKUP략믘쪱쫇뺫좷욥엤뮹쫇뷼쯆욥엤ꆣ 쫽뻝뿢몯쫽?䑁噅剁䝅?릦쓜ꎺ략믘쇐뇭믲쫽뻝뿢훐싺ퟣ횸뚨쳵볾뗄쇐훐쫽횵뗄욽뻹횵ꆣ 뇭듯쪽ꎺDAVERAGE(database,field,criteria)?닎쫽몬틥ꎺ Database 릹돉쇐뇭믲쫽뻝뿢뗄떥풪룱쟸폲ꆣ Field 횸뚨몯쫽쯹쪹폃뗄쫽뻝쇐ꆣ쇐뇭훐뗄쫽뻝쇐뇘탫퓚뗚튻탐뻟폐뇪횾쿮ꆣ Criteria 캪튻ퟩ냼몬룸뚨쳵볾뗄떥풪룱쟸폲ꆣ 䑃何乔?릦쓜ꎺ략믘쫽뻝뿢믲쇐뇭뗄쇐훐싺ퟣ횸뚨쳵볾늢쟒냼몬쫽ퟖ뗄떥풪룱룶쫽ꆣ 뇭듯쪽ꎺDCOUNT(database,field,criteria)?닎쫽몬틥ꎺ춬짏ꆣ 䑃何乔??릦쓜ꎺ략믘쫽뻝뿢믲쇐뇭뗄쇐훐싺ퟣ횸뚨쳵볾뗄럇뿕떥풪룱룶쫽ꆣ 뇭듯쪽ꎺDCOUNTA(database,field,criteria)?닎쫽몬틥ꎺ춬짏ꆣ 䑇䕔?릦쓜ꎺ듓쇐뇭믲쫽뻝뿢뗄쇐훐쳡좡럻뫏횸뚨쳵볾뗄떥룶횵ꆣ 뇭듯쪽ꎺDGET(database,field,criteria)?닎쫽몬틥ꎺ춬짏ꆣ 䑍䅘?릦쓜ꎺ략믘쇐뇭믲쫽뻝뿢뗄쇐훐싺ퟣ횸뚨쳵볾뗄ퟮ듳쫽횵ꆣ 뇭듯쪽ꎺDMAX(database,field,criteria)?닎쫽몬틥ꎺ춬짏ꆣ 䑍䥎?릦쓜ꎺ략믘쇐뇭믲쫽뻝뿢뗄쇐훐싺ퟣ횸뚨쳵볾뗄ퟮ킡쫽ퟖꆣ 뇭듯쪽ꎺDMIN(database,field,criteria)?닎쫽몬틥ꎺ춬짏ꆣ 䑐剏䑕䍔?릦쓜ꎺ략믘쇐뇭믲쫽뻝뿢뗄쇐훐싺ퟣ횸뚨쳵볾뗄쫽횵뗄돋믽ꆣ 뇭듯쪽ꎺDPRODUCT(database,field,criteria)?34
뢽슼 닎쫽몬틥ꎺ춬짏ꆣ 䑓呄䕖?릦쓜ꎺ붫쇐뇭믲쫽뻝뿢뗄쇐훐싺ퟣ횸뚨쳵볾뗄쫽ퟖퟷ캪튻룶퇹놾ꎬ맀쯣퇹놾ퟜ쳥뗄뇪ힼ욫닮ꆣ 뇭듯쪽ꎺDSTDEV(database,field,criteria)?닎쫽몬틥ꎺ춬짏ꆣ 䑓呄䕖??릦쓜ꎺ붫쇐뇭믲쫽뻝뿢뗄쇐훐싺ퟣ횸뚨쳵볾뗄쫽ퟖퟷ캪퇹놾ퟜ쳥ꎬ볆쯣ퟜ쳥뗄뇪ힼ욫닮ꆣ 뇭듯쪽ꎺDSTDEVP(database,field,criteria)?닎쫽몬틥ꎺ춬짏ꆣ 䑓啍?릦쓜ꎺ략믘쇐뇭믲쫽뻝뿢뗄쇐훐싺ퟣ횸뚨쳵볾뗄쫽ퟖ횮뫍ꆣ 뇭듯쪽ꎺDSUM(database,field,criteria)?닎쫽몬틥ꎺ춬짏ꆣ 䑖䅒?릦쓜ꎺ붫쇐뇭믲쫽뻝뿢뗄쇐훐싺ퟣ횸뚨쳵볾뗄쫽ퟖퟷ캪튻룶퇹놾ꎬ맀쯣퇹놾ퟜ쳥뗄랽닮ꆣ 뇭듯쪽ꎺDVAR(database,field,criteria)?닎쫽몬틥ꎺ춬짏ꆣ 䑖䅒??릦쓜ꎺ붫쇐뇭믲쫽뻝뿢뗄쇐훐싺ퟣ횸뚨쳵볾뗄쫽ퟖퟷ캪퇹놾ퟜ쳥ꎬ볆쯣ퟜ쳥뗄랽닮ꆣ 뇭듯쪽ꎺDVARP(database,field,criteria)?닎쫽몬틥ꎺ춬짏ꆣ 컄놾몯쫽?䅓??릦쓜ꎺ뛔폚쮫ퟖ뷚ퟖ럻벯(DBCS)폯퇔ꎬ붫좫뷇ퟖ럻룼룄캪냫뷇ퟖ럻ꆣ 뇭듯쪽ꎺASC(text)?닎쫽몬틥ꎺ Text 캪컄놾믲뛔냼몬튪룼룄컄놾뗄떥풪룱뗄틽폃ꆣ 䍈䅒?릦쓜ꎺ략믘뛔펦폚쫽ퟖ듺싫뗄ퟖ럻ꆣ 뇭듯쪽ꎺCHAR(number)?닎쫽몬틥ꎺ Number 쫇폃폚뮻뗄ퟖ럻듺싫ꎬ뷩폚1떽255횮볤ꆣ 35
뷜돏3컄6 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 䍌䕁??릦쓜ꎺ즾돽컄놾훐늻쓜듲펡뗄ퟖ럻ꆣ 뇭듯쪽ꎺCLEAN(text)?닎쫽몬틥ꎺ Text 컄놾쫇튪듓훐즾돽늻쓜듲펡ퟖ럻뗄죎뫎릤ퟷ뇭탅쾢ꆣ 䍏䑅?릦쓜ꎺ략믘컄놾ퟖ럻뒮훐뗚튻룶ퟖ럻뗄쫽ퟖ듺싫ꆣ 뇭듯쪽ꎺCODE(text)?닎쫽몬틥ꎺ Text 캪탨튪뗃떽웤뗚튻룶ퟖ럻듺싫뗄컄놾ꆣ 䍏乃䅔䕎䅔??릦쓜ꎺ붫벸룶컄놾ퟖ럻뒮뫏늢캪튻룶컄놾ퟖ럻뒮ꆣ 뇭듯쪽ꎺCONCATENATE (text1,text2,...)?닎쫽몬틥ꎺ Text1, text2, ... 캪1떽30룶붫튪뫏늢돉떥룶컄놾쿮뗄컄놾쿮ꆣ 䑏䱌䅒믲前??릦쓜ꎺ룃몯쫽틀헕믵뇒룱쪽붫킡쫽쯄짡컥죫떽횸뚨뗄캻쫽늢뮻돉컄놾ꆣ 뇭듯쪽ꎺDOLLAR 믲 RMB(number,decimals)?닎쫽몬틥ꎺ Number 캪쫽ퟖꆢ냼몬쫽ퟖ뗄떥풪룱틽폃ꎬ믲쫇볆쯣뷡맻캪쫽ퟖ뗄릫쪽ꆣ Decimals 캪쪮뷸훆쫽뗄킡쫽캻쫽ꆣ 䕘䅃??릦쓜ꎺ룃몯쫽닢쫔솽룶ퟖ럻뒮쫇럱췪좫쿠춬ꆣ췪좫쿠춬략믘TRUEꎻ럱퓲략믘FALSEꆣ 뇭듯쪽ꎺEXACT(text1,text2)?닎쫽몬틥ꎺ Text1 듽뇈뷏뗄뗚튻룶ퟖ럻뒮ꆣ Text2 듽뇈뷏뗄뗚뛾룶ퟖ럻뒮ꆣ 䙉乄?릦쓜ꎺ폃폚닩헒웤쯻컄놾ퟖ럻뒮(within_text)쓚뗄컄놾ퟖ럻뒮(find_text)ꎬ늢듓within_text뗄쫗ퟖ럻뾪쪼략믘find_text뗄웰쪼캻훃뇠뫅ꆣ 뇭듯쪽ꎺFIND(find_text,within_text,start_num)?닎쫽몬틥ꎺ Find_text 쫇튪닩헒뗄컄놾ꆣ Within_text 쫇냼몬튪닩헒컄놾뗄컄놾ꆣ Start_num 횸뚨뾪쪼뷸탐닩헒뗄ퟖ럻ꆣ 36
뢽슼 䙉乄??릦쓜ꎺ폃폚닩헒웤쯻컄놾ퟖ럻뒮(within_text)쓚뗄컄놾ퟖ럻뒮(find_text)ꎬ늢믹폚쎿룶ퟖ럻쯹쪹폃뗄ퟖ뷚쫽듓within_text뗄쫗ퟖ럻뾪쪼략믘find_text뗄웰쪼캻훃뇠뫅ꆣ듋몯쫽폃폚쮫ퟖ뷚ퟖ럻ꆣ 뇭듯쪽ꎺFINDB(find_text,within_text,start_num)?닎쫽몬틥ꎺ춬짏ꆣ 䙉塅??릦쓜ꎺ붫쫽ퟖ내횸뚨뗄킡쫽캻쫽뷸탐좡헻ꎬ샻폃뻤뫅뫍뚺뫅ꎬ틔킡쫽룱쪽뛔룃쫽뷸탐룱쪽짨훃ꎬ늢틔컄놾탎쪽략믘뷡맻ꆣ 뇭듯쪽ꎺFIXED(number,decimals,no_commas)?닎쫽몬틥ꎺ Number 튪뷸탐쯄짡컥죫늢뮻돉컄놾ퟖ럻뒮뗄쫽ꆣ Decimals 캪튻쫽횵ꎬ폃틔횸뚨킡쫽뗣폒뇟뗄킡쫽캻쫽ꆣ No_commas 캪튻싟벭횵ꆣ 䱅???릦쓜ꎺ믹폚쯹횸뚨뗄ퟖ럻쫽략믘컄놾ퟖ럻뒮훐뗄뗚튻룶믲잰벸룶ퟖ럻ꆣ 뇭듯쪽ꎺLEFT(text,num_chars)?닎쫽몬틥ꎺ Text 쫇냼몬튪쳡좡ퟖ럻뗄컄놾ퟖ럻뒮ꆣ Num_chars 횸뚨튪평LEFT쯹쳡좡뗄ퟖ럻쫽ꆣ 䱅䙔??릦쓜ꎺ믹폚쯹횸뚨뗄ퟖ뷚쫽략믘컄놾ퟖ럻뒮훐뗄뗚튻룶믲잰벸룶ퟖ럻ꆣ듋몯쫽폃폚쮫ퟖ뷚ퟖ럻ꆣ 뇭듯쪽ꎺLEFTB(text,num_bytes)?닎쫽몬틥ꎺ Text 쫇냼몬튪쳡좡ퟖ럻뗄컄놾ퟖ럻뒮ꆣ num_bytes 횸뚨튪평LEFT룹뻝ퟖ뷚쯹쳡좡뗄ퟖ럻쫽ꆣ 䱅??릦쓜ꎺ략믘컄놾ퟖ럻뒮훐뗄ퟖ럻쫽ꆣ 뇭듯쪽ꎺLEN(text)?닎쫽몬틥ꎺ Text 쫇튪닩헒웤뎤뛈뗄컄놾ꆣ뿕룱붫ퟷ캪ퟖ럻뷸탐볆쫽ꆣ 䱅乂?릦쓜ꎺ략믘컄놾ퟖ럻뒮훐폃폚듺뇭ퟖ럻뗄ퟖ뷚쫽ꆣ듋몯쫽폃폚쮫ퟖ뷚ퟖ럻ꆣ 뇭듯쪽ꎺLENB(text)?닎쫽몬틥ꎺ춬짏ꆣ 37
뷜돏3컄8 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 䱏坅??릦쓜ꎺ붫튻룶컄놾ퟖ럻뒮훐뗄쯹폐듳킴ퟖ쒸뮻캪킡킴ퟖ쒸ꆣ 뇭듯쪽ꎺLOWER(text)?닎쫽몬틥ꎺ Text 쫇튪뮻캪킡킴ퟖ쒸뗄컄놾ꆣ 䵉??릦쓜ꎺ략믘컄놾ퟖ럻뒮훐듓횸뚨캻훃뾪쪼뗄쳘뚨쫽쒿뗄ퟖ럻ꎬ룃쫽쒿평폃뮧횸뚨ꆣ 뇭듯쪽ꎺMID(text,start_num,num_chars)?닎쫽몬틥ꎺ Text 쫇냼몬튪쳡좡ퟖ럻뗄컄놾ퟖ럻뒮ꆣ 쫇컄놾훐튪쳡좡뗄뗚튻룶ퟖ럻뗄캻훃ꆣ컄놾훐뗚튻룶ퟖ럻뗄start_num Start_num 캪 1ꎬ틔듋샠췆ꆣ Num_chars 횸뚨쾣췻MID듓컄놾훐략믘ퟖ럻뗄룶쫽ꆣ 䵉䑂?릦쓜ꎺ략믘컄놾ퟖ럻뒮훐듓횸뚨캻훃뾪쪼뗄쳘뚨쫽쒿뗄ퟖ럻ꎬ룃쫽쒿평폃뮧횸뚨ꆣ듋몯쫽폃폚쮫ퟖ뷚ퟖ럻ꆣ 뇭듯쪽ꎺMIDB(text,start_num,num_bytes)?닎쫽몬틥ꎺ Text 쫇냼몬튪쳡좡ퟖ럻뗄컄놾ퟖ럻뒮ꆣ 쫇컄놾훐튪쳡좡뗄뗚튻룶ퟖ럻뗄캻훃ꆣ컄놾훐뗚튻룶ퟖ럻뗄start_numStart_num 캪 1ꎬ틔듋샠췆ꆣ Num_bytes 횸뚨쾣췻MIDB듓컄놾훐략믘ퟖ럻뗄룶쫽ꎨ내ퟖ뷚ꎩꆣ 偒佐䕒?릦쓜ꎺ붫컄놾ퟖ럻뒮뗄쫗ퟖ쒸벰죎뫎럇ퟖ쒸ퟖ럻횮뫳뗄쫗ퟖ쒸뮻돉듳킴ꆣ 뇭듯쪽ꎺPROPER(text)?닎쫽몬틥ꎺ Text 냼삨퓚튻ퟩ쮫틽뫅훐뗄컄놾ퟖ럻뒮ꆢ략믘컄놾횵뗄릫쪽믲쫇뛔냼몬컄놾뗄떥풪룱뗄틽폃ꆣ 剅偌䅃??릦쓜ꎺ쪹폃웤쯻컄놾ퟖ럻뒮늢룹뻝쯹횸뚨뗄ퟖ럻쫽쳦뮻쒳컄놾ퟖ럻뒮훐뗄늿럖컄놾ꆣ 뇭듯쪽ꎺREPLACE(old_text,start_num,num_chars,new_text)?닎쫽몬틥ꎺ Old_text 쫇튪쳦뮻웤늿럖ퟖ럻뗄컄놾ꆣ Start_num 쫇튪폃new_text쳦뮻뗄old_text훐ퟖ럻뗄캻훃ꆣ Num_chars 쫇쾣췻REPLACE쪹폃new_text쳦뮻old_text훐ퟖ럻뗄룶쫽ꆣ New_text 쫇튪폃폚쳦뮻old_text훐ퟖ럻뗄컄놾ꆣ 剅偌䅃䕂?릦쓜ꎺ쪹폃웤쯻컄놾ퟖ럻뒮늢룹뻝쯹횸뚨뗄ퟖ럻쫽쳦뮻쒳컄놾ퟖ럻뒮훐뗄늿럖컄놾ꆣ듋38
뢽슼 몯쫽캪쮫ퟖ뷚ퟖ럻쪹폃ꆣ 뇭듯쪽ꎺREPLACEB(old_text,start_num,num_bytes,new_text)?닎쫽몬틥ꎺ Old_text 쫇튪쳦뮻웤늿럖ퟖ럻뗄컄놾ꆣ Start_num 쫇튪폃new_text쳦뮻뗄old_text훐ퟖ럻뗄캻훃ꆣ Num_bytes 쫇쾣췻REPLACE쪹폃new_text쳦뮻old_text훐ퟖ뷚뗄룶쫽 New_text 쫇튪폃폚쳦뮻old_text훐ퟖ럻뗄컄놾ꆣ ?䕐??릦쓜ꎺ내헕룸뚨뗄듎쫽훘뢴쿔쪾컄놾ꆣ 뇭듯쪽ꎺREPT(text,number_times)?닎쫽몬틥ꎺ Text 탨튪훘뢴쿔쪾뗄컄놾ꆣ Number_times 쫇횸뚨컄놾훘뢴듎쫽뗄헽쫽ꆣ 剉䝈??릦쓜ꎺ룹뻝쯹횸뚨뗄ퟖ럻쫽략믘컄놾ퟖ럻뒮훐ퟮ뫳튻룶믲뛠룶ퟖ럻ꆣ 뇭듯쪽ꎺRIGHT(text,num_chars)?닎쫽몬틥ꎺ Text 쫇냼몬튪쳡좡ퟖ럻뗄컄놾ퟖ럻뒮ꆣ Num_chars 횸뚨쾣췻RIGHT쳡좡뗄ퟖ럻쫽ꆣ 剉䝈呂?릦쓜ꎺ룹뻝쯹횸뚨뗄ퟖ럻쫽략믘컄놾ퟖ럻뒮훐ퟮ뫳튻룶믲뛠룶ퟖ럻ꆣ듋몯쫽폃폚쮫ퟖ뷚ퟖ럻ꆣ 뇭듯쪽ꎺRIGHTB(text,num_bytes)?닎쫽몬틥ꎺ Text 쫇냼몬튪쳡좡ퟖ럻뗄컄놾ퟖ럻뒮ꆣ Num_bytes 횸뚨쾣췻RIGHTB룹뻝ퟖ뷚쯹쳡좡뗄ퟖ럻쫽ꆣ 卅䅒䍈?릦쓜ꎺ략믘듓start_num뾪쪼쫗듎헒떽쳘뚨ퟖ럻믲컄놾ퟖ럻뒮뗄캻훃짏쳘뚨ퟖ럻뗄뇠뫅ꆣ 뇭듯쪽ꎺSEARCH(find_text,within_text,start_num)?닎쫽몬틥ꎺ Find_text 쫇튪닩헒뗄컄놾ꆣ Within_text 쫇튪퓚웤훐닩헒find_text뗄컄놾ꆣ Start_num 쫇within_text훐뾪쪼닩헒뗄ퟖ럻뗄뇠뫅ꆣ 卅䅒䍈??릦쓜ꎺ퓚웤쯻컄놾ퟖ럻뒮 (within_text) 훐닩헒컄놾ퟖ럻뒮 (find_text)ꎬ늢략믘 find_text 뗄웰쪼캻훃뇠뫅ꎬ뷡맻쫇듓 start_num 뾪쪼뗄ꆣ듋몯쫽폃폚쮫ퟖ뷚ퟖ럻ꆣ 39
뷜돏4컄0 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 뇭듯쪽ꎺSEARCHB(find_text,within_text,start_num)?닎쫽몬틥ꎺ춬짏ꆣ 单䉓呉呕呅?릦쓜ꎺ퓚컄놾ퟖ럻뒮훐폃 new_text 쳦듺 old_textꆣ 뇭듯쪽ꎺSUBSTITUTE(text,old_text,new_text,instance_num)?닎쫽몬틥ꎺ Text 캪탨튪쳦뮻웤훐ퟖ럻뗄컄놾ꎬ믲뛔몬폐컄놾뗄떥풪룱뗄틽폃ꆣ Old_text 캪탨튪쳦뮻뗄뻉컄놾ꆣ New_text 폃폚쳦뮻old_text뗄컄놾ꆣ Instance_num 캪튻쫽횵ꎬ폃살횸뚨틔new_text쳦뮻뗚벸듎돶쿖뗄old_textꆣ ??릦쓜ꎺ략믘value틽폃뗄컄놾ꆣ 뇭듯쪽ꎺT(value)?닎쫽몬틥ꎺ Value 캪탨튪뷸탐볬퇩뗄쫽횵ꆣ 呅塔?릦쓜ꎺ붫쫽횵뮻캪내횸뚨쫽ퟖ룱쪽뇭쪾뗄컄놾ꆣ 뇭듯쪽ꎺTEXT(value,format_text)?닎쫽몬틥ꎺ Value 캪쫽횵ꆢ볆쯣뷡맻캪쫽ퟖ횵뗄릫쪽ꎬ믲뛔냼몬쫽ퟖ횵뗄떥풪룱뗄틽폃ꆣ Format_text 캪“떥풪룱룱쪽”뛔뮰뿲훐“쫽ퟖ”톡쿮뾨짏“럖샠”뿲훐뗄컄놾탎쪽뗄쫽ퟖ룱쪽ꆣ 呒䥍?릦쓜ꎺ돽쇋떥듊횮볤뗄떥룶뿕룱췢ꎬ쟥돽컄놾훐쯹폐뗄뿕룱ꆣ 뇭듯쪽ꎺTRIM(text)?닎쫽몬틥ꎺ Text 탨튪쟥돽웤훐뿕룱뗄컄놾ꆣ 啐?䕒?릦쓜ꎺ붫컄놾뮻돉듳킴탎쪽ꆣ 뇭듯쪽ꎺUPPER(text)?닎쫽몬틥ꎺ Text 캪탨튪뮻돉듳킴탎쪽뗄컄놾ꆣ 噁䱕??릦쓜ꎺ붫듺뇭쫽ퟖ뗄컄놾ퟖ럻뒮뮻돉쫽ퟖꆣ 뇭듯쪽ꎺVALUE(text)?닎쫽몬틥ꎺ Text 캪듸틽뫅뗄컄놾ꎬ믲뛔탨튪뷸탐컄놾뮻뗄떥풪룱뗄틽폃ꆣ 40
뢽슼 싟벭몯쫽?䅎??릦쓜ꎺ쯹폐닎쫽뗄싟벭횵캪헦쪱ꎬ략믘TRUEꎻ횻튪튻룶닎쫽뗄싟벭횵캪볙ꎬ략믘FALSEꆣ 뇭듯쪽ꎺAND(logical1,logical2, ...)?닎쫽몬틥ꎺ Logical1, logical2, ... 뇭쪾듽볬닢뗄1떽30룶쳵볾횵ꎬ룷쳵볾횵뿉캪TRUE믲FALSE 䙁䱓??릦쓜ꎺ략믘싟벭횵 FALSEꆣ 뇭듯쪽ꎺFALSE( )?䥆?릦쓜ꎺ횴탐헦볙횵에뛏ꎬ룹뻝싟벭볆쯣뗄헦볙횵ꎬ략믘늻춬뷡맻ꆣ 뇭듯쪽ꎺIF(logical_test,value_if_true,value_if_false)?닎쫽몬틥ꎺ Logical_test 뇭쪾볆쯣뷡맻캪TRUE믲FALSE뗄죎틢횵믲뇭듯쪽ꆣ Value_if_true logical_test캪TRUE쪱략믘뗄횵ꆣ Value_if_false logical_test캪FALSE쪱략믘뗄횵ꆣ 乏??릦쓜ꎺ뛔닎쫽횵쟳랴ꆣ 뇭듯쪽ꎺNOT(logical)?닎쫽몬틥ꎺ Logical 캪튻룶뿉틔볆쯣돶 佒?릦쓜ꎺ퓚웤닎쫽ퟩ훐죎뫎튻룶닎쫽싟벭횵캪TRUEꎬ략믘TRUEꎻ죎뫎튻룶닎쫽뗄싟벭횵캪FALSEꎬ략믘FALSEꆣ 뇭듯쪽ꎺOR(logical1,logical2,...)?닎쫽몬틥ꎺ Logical1, logical2, ... 뇭쪾듽볬닢뗄1떽30룶쳵볾횵ꎬ룷쳵볾횵뿉캪TRUE믲FALSE 呒啅?릦쓜ꎺ략믘싟벭횵TRUEꆣ 뇭듯쪽ꎺTRUE( )?탅쾢몯쫽?䍅䱌?릦쓜ꎺ략믘쒳튻틽폃쟸폲뗄ퟳ짏뷇떥풪룱뗄룱쪽ꆢ캻훃믲쓚죝뗈탅쾢ꆣ 41
뷜돏4컄2 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 뇭듯쪽ꎺCELL(info_type,reference)?닎쫽몬틥ꎺ Info_type 캪튻룶컄놾횵ꎬ횸뚨쯹탨튪뗄떥풪룱탅쾢뗄샠탍ꆣ Reference 뇭쪾튪믱좡웤폐맘탅쾢뗄떥풪룱ꆣ 䕒剏刮呙偅?릦쓜ꎺ략믘뛔펦폚Microsoft Excel훐쒳튻듭컳횵뗄쫽ퟖꎬ죧맻쎻폐듭컳퓲략믘#N/Aꆣ 뇭듯쪽ꎺ(error_val)?닎쫽몬틥ꎺ Error_val 캪탨튪뗃떽웤뇪뫅뗄튻룶듭컳횵ꆣ 䥎䙏?릦쓜ꎺ략믘폐맘떱잰닙ퟷ뮷뺳뗄탅쾢ꆣ 뇭듯쪽ꎺINFO(type_text)?닎쫽몬틥ꎺ Type_text 캪컄놾ꎬ횸쏷쯹튪략믘뗄탅쾢샠탍ꆣ 䥓䉌䅎??릦쓜ꎺ볬퇩쫽횵쫇럱캪뿕냗떥풪룱ꎬ죴쫇략믘TRUEꎬ럱퓲략믘FALSEꆣ 뇭듯쪽ꎺISBLANK(value)?닎쫽몬틥ꎺ Value 캪탨튪뷸탐볬퇩뗄쫽횵ꆣ 䥓䕒??릦쓜ꎺ볬퇩쫽횵쫇럱캪죎틢듭컳횵ꎨ돽좥 #N/Aꎩꎬ죴쫇략믘TRUEꎬ럱퓲략믘FALSEꆣ 뇭듯쪽ꎺISERR(value)?닎쫽몬틥ꎺ춬짏ꆣ 䥓䕒剏??릦쓜ꎺ볬퇩쫽횵쫇럱캪죎틢듭컳횵ꎬ죴쫇략믘TRUEꎬ럱퓲략믘FALSEꆣ 뇭듯쪽ꎺISERROR(value)?닎쫽몬틥ꎺ춬짏ꆣ 䥓䱏䝉䍁??릦쓜ꎺ볬퇩쫽횵쫇럱캪싟벭횵ꎬ죴쫇략믘TRUEꎬ럱퓲략믘FALSEꆣ 뇭듯쪽ꎺISLOGICAL(value)?닎쫽몬틥ꎺ춬짏ꆣ 䥓乁?릦쓜ꎺ볬퇩쫽횵쫇럱캪듭컳횵 #N/Aꎨ횵늻듦퓚ꎩꎬ죴쫇략믘TRUEꎬ럱퓲략믘FALSEꆣ 뇭듯쪽ꎺISNA(value)?닎쫽몬틥ꎺ춬짏ꆣ 42
뢽슼 䥓乏乔䕘??릦쓜ꎺ볬퇩쫽횵쫇럱캪늻쫇컄놾뗄죎틢쿮ꎬ죴쫇략믘TRUEꎬ럱퓲략믘FALSEꆣ 뇭듯쪽ꎺISNONTEXT(value)?닎쫽몬틥ꎺ춬짏ꆣ 䥓乕䵂䕒?릦쓜ꎺ볬퇩쫽횵쫇럱캪쫽ퟖꎬ죴쫇략믘TRUEꎬ럱퓲략믘FALSEꆣ 뇭듯쪽ꎺISNUMBER(value)?닎쫽몬틥ꎺ춬짏ꆣ 䥓剅??릦쓜ꎺ볬퇩쫽횵쫇럱캪틽폃ꎬ죴쫇략믘TRUEꎬ럱퓲략믘FALSEꆣ 뇭듯쪽ꎺISREF(value)?닎쫽몬틥ꎺ춬짏ꆣ 䥓呅塔?릦쓜ꎺ볬퇩쫽횵쫇럱캪컄놾ꎬ죴쫇략믘TRUEꎬ럱퓲략믘FALSEꆣ 뇭듯쪽ꎺISTEXT(value)?닎쫽몬틥ꎺ춬짏ꆣ ??릦쓜ꎺ략믘뮯캪쫽횵뫳뗄횵ꆣ 뇭듯쪽ꎺN(value)?닎쫽몬틥ꎺ Value 캪튪뮯뗄횵ꆣ 乁?릦쓜ꎺ략믘듭컳횵#N/Aꆣ 뇭듯쪽ꎺNA( )?呙偅?릦쓜ꎺ략믘쫽횵뗄샠탍ꆣ 뇭듯쪽ꎺTYPE(value)?닎쫽몬틥ꎺ Value 뿉틔캪죎틢Microsoft Excel쫽횵ꎬ죧쫽ퟖꆢ컄놾틔벰싟벭횵뗈뗈ꆣ 43
뷜돏4컄4 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 뢽슼䌠?춼뇭샠탍?Excel훐뗄춼뇭샠탍럖캪뇪ힼ샠탍뫍ퟔ뚨틥샠탍솽샠ꎬ웤훐뇪ힼ샠탍폐14훖춼뇭샠탍릲73훖춼뇭ퟓ샠탍ꎬퟔ뚨틥샠탍냼삨20훖쓚늿춼뇭샠탍ꆣ 쿂쏦샻폃죧춼Cꎭ001쯹쪾뗄뇭룱쫽뻝믦훆춼뇭ꎺ 춼 Cꎭ001 쫽뻝쟸폲 뇪ힼ샠탍?ㄮ†훹탎춼? 춼Cꎭ002 듘ힴ훹탎춼 춼Cꎭ003 뛑믽훹탎춼 춼Cꎭ004 냙럖뇈뛑믽훹탎춼 춼Cꎭ005 죽캬듘ힴ훹탎춼 44
뢽슼 춼Cꎭ006 죽캬뛑믽훹탎춼 춼Cꎭ007 죽캬냙럖뇈뛑믽훹탎춼 춼 Cꎭ008 죽캬훹탎춼 ??†쳵탎춼?춼ꎭ C009 듘ힴ쳵탎춼 춼Cꎭ010 뛑믽쳵탎춼 춼 Cꎭ011 냙럖뇈뛑믽쳵탎춼 춼Cꎭ012 죽캬듘ힴ쳵탎춼 45
뷜돏4컄6 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 춼Cꎭ013 죽캬뛑믽쳵탎춼 춼Cꎭ014 죽캬냙럖뇈뛑믽쳵탎춼 ??†헛쿟춼? 춼Cꎭ015 헛쿟춼 춼Cꎭ016 뛑믽헛쿟춼 춼Cꎭ017 냙럖뇈뛑믽헛쿟춼 춼Cꎭ018 쫽뻝뗣헛쿟춼 춼Cꎭ019 뛑믽쫽뻝뗣헛쿟춼 춼Cꎭ020 냙럖뇈뛑믽쫽뻝뗣헛쿟춼 46
뢽슼 춼ꎭ C021 죽캬헛쿟춼 ??†뇽춼? 춼Cꎭ022 뇽춼 춼Cꎭ023 죽캬뇽춼 춼Cꎭ024 뢴뫏뇽춼 춼Cꎭ025 럖샫탍뇽춼 춼Cꎭ026 럖샫탍죽캬뇽춼 춼Cꎭ027 뢴뫏쳵뇽춼 47
뷜돏4컄8 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 ??†塙즢뗣춼? 춼Cꎭ028 즢뗣춼 춼Cꎭ029 욽뮬쿟즢뗣춼 춼 Cꎭ030 컞쫽뻝뗣욽뮬쿟즢뗣춼 춼Cꎭ031 헛쿟즢뗣춼 춼Cꎭ032 컞쫽뻝뗣헛쿟즢뗣춼 ??†쏦믽춼? 춼Cꎭ033 쏦믽춼 춼Cꎭ034 뛑믽쏦믽춼 48
뢽슼 춼 Cꎭ035 냙럖뇈뛑믽쏦믽춼 춼Cꎭ036 죽캬쏦믽춼 춼Cꎭ037 죽캬뛑믽쏦믽춼 춼Cꎭ038 죽캬냙럖뇈뛑믽춼 ??†풲뮷춼? 춼Cꎭ039 풲뮷춼 춼Cꎭ040 럖샫탍풲뮷춼 ??†샗듯춼? 춼Cꎭ041 샗듯춼 춼Cꎭ042 쫽뻝뗣샗듯춼 49
뷜돏5컄0 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 춼 Cꎭ043 쳮돤샗듯춼 ??†쟺쏦춼? 춼Cꎭ044 죽캬쟺쏦춼 춼Cꎭ045 죽캬쟺쏦춼ꎨ뿲볜춼ꎩ 춼Cꎭ046 쟺쏦춼ꎨ뢩쫓ꎩ 춼Cꎭ047 쟺쏦춼ꎨ뢩쫓뿲볜춼ꎩ ?†웸엝춼? 춼Cꎭ048 웸엝춼 춼Cꎭ049 죽캬웸엝춼 50
뢽슼 ㄱ?†막볛춼?춼 Cꎭ050 막욱쫽뻝 춼Cꎭ051 엌룟ꎭ엌뗍ꎭ쫕엌춼 춼Cꎭ052 뾪엌ꎭ엌룟ꎭ엌뗍ꎭ쫕엌춼 춼Cꎭ053 돉붻솿ꎭ엌룟ꎭ엌뗍ꎭ쫕엌춼 춼Cꎭ054 돉붻솿ꎭ뾪엌ꎭ엌룟ꎭ엌뗍ꎭ쫕엌춼 ㄲ?†풲훹춼?춼 Cꎭ055 훹탎풲훹춼 춼Cꎭ056 뛑믽훹탎풲훹춼 51
뷜돏5컄2 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 춼 Cꎭ057 냙럖뇈뛑믽훹탎풲훹춼 춼Cꎭ058 쳵탎풲훹춼 춼 Cꎭ059 뛑믽쳵탎풲훹춼 춼Cꎭ060 냙럖뇈뛑믽쳵탎풲훹춼 춼 Cꎭ061 죽캬훹탎풲훹춼 ㄳ?†풲ힶ춼? 춼Cꎭ062 훹탎풲ힶ춼 춼Cꎭ063 뛑믽훹탎풲ힶ춼 52
뢽슼 춼믽훹탎풲ힶ춼 Cꎭ064 냙럖뇈뛑 춼Cꎭ065 쳵탎풲ힶ춼 춼Cꎭ066 뛑믽쳵탎풲ힶ춼 춼Cꎭ067 냙럖뇈뛑믽쳵탎풲ힶ춼 춼 Cꎭ068 죽캬훹탎풲훹춼 ㄴ?†샢ힶ춼? 춼Cꎭ069 훹탎샢ힶ춼 춼Cꎭ070 뛑믽훹탎샢ힶ춼 53
뷜돏5컄4 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 춼 Cꎭ071 냙럖뇈뛑믽훹탎샢ힶ춼 춼Cꎭ072 쳵탎샢ힶ춼 춼 Cꎭ073 뛑믽쳵탎샢ힶ춼 춼Cꎭ074 냙럖뇈뛑믽쳵탎샢ힶ춼 춼 Cꎭ075 죽캬훹탎샢ힶ춼 ퟔ뚨틥샠탍?춼 Cꎭ076 닊즫뛑믽춼 춼Cꎭ077 닊즫헛쿟춼 54
뢽슼 춼춼 Cꎭ078 듸짮뛈뗄훹탎 춼Cꎭ079 뛔쫽춼 춼 Cꎭ080 럖쇑뗄뇽춼 춼Cꎭ081 맜ힴ춼 춼 Cꎭ082 뫚냗뇽춼 춼Cꎭ083 뫚냗쏦믽춼 춼 Cꎭ084 뫚냗헛쿟춼ꎭ쪱볤뿌뛈 춼Cꎭ085 뫚냗훹탎춼 55
뷜돏5컄6 뮯 쫂 뎬튵쏎랢믃햹뺢훐놬탄췸튳Dreamweaver MXꆢFlash MXꆢFireworks MX췪짆뷡뫏 춼Cꎭ086 삯뇊춼 춼Cꎭ087 삶즫뇽춼 춼Cꎭ088 솽훡쿟-훹춼 춼Cꎭ089 솽훡헛쿟춼 춼 Cꎭ090 욽뮬횱쿟춼 춼Cꎭ091 쿟-훹춼 춼Cꎭ092 탼뢡뗄쳵탎춼 춼Cꎭ093 풲ힶ춼 56
뢽슼 춼ꎭ C094 훹ힴ-쏦믽춼 춼Cꎭ095 ퟔ좻쳵탎춼 57
