Excel腑熅焯樿泂ょヰ伊嶬驤Ъ┚聆┚驤┚蹍┚13┚弓44?王坂霙ヰ吹令49澐

腑│尻閻A焯樿客愛13餒泭背TRUE(13);盡│尻閻A焯樿客愛弓＄細泭背FALSE(弓毗

尻閻

Loicl1loicl＄;愛炸ぅ'19A1Ｅ30х焯樿と毚淆＄壟凹A禺拖聆愛TRUE(13)聆愛FALSE(弓)┛尻閻犲普驤焯樿客AND岌泭背園氅客#value!┛奬掛

苓A1=2┚A=6＄畬梓梧淆9=A(A1A2):泭背FALSE┛苓B4=104＄畬梓梧淆工.FAL49澐

泭背焯樿客毗

尻閻

檔砂閻Щ蝝?尻奬掛

苓∠板A1鋤舷?坑橺午梧淆9=FALSE():＄背??據(jù)昌靭泭背FALSE┛朅板鋤舷?聆梧淆ш橺午陷垓FALSE＄Excel科勈蒔岌壟??耜焯樿客FALSE┛左49と毚淆A13弓＄泭背Щ趨A禺∠＄閲澘臾が閻客聆梧淆A?王ぅ\黃璽┛毗/

IFloicl_est＄aue_i_true＄lueif_ale)┛尻閻

Logical_test嶤ょ禺∠愛TRUE聆FALSEA黃皆閻客聆と毚淆;value_if_true驤Logical_test愛TRUE餒砂閻A泭背客苓logical_test愛TRUE槭а水j芋value_if_true＄細泭背TRUE┛澘аvalue_if_true靭遠驤Мхと毚淆;value_if_false驤Logical_test愛FALSE餒砂閻A泭背客┛苓∠logical_test愛FALSE槭а水jvalue_if_false＄細泭背FALSE┛value_if_false伊靭遠驤Мхと毚奬掛

梧淆9=IF(C>=8"A"IF(2>=0"BIF(2>=60"C"F(C2<6"D"))))交ш?因хIF毗刃趨餒伊驤?IF毗刃A尻閻┛趨逼＄?ХхIF毗刃驤?因хIF毗刃A尻閻＄遠繒+褥┛掛苓＄朅?Мх焯樿坂霙と毚淆C2>=85耜わ＄細D2鋤9A;NO49澐

査Мх焯樿客聆焯樿と毚淆Aロ新客┛苓∠矣??観Мх焯樿客4引交ロ新客＄嶬櫂檔角49NOT砂閻毗

尻閻

Logical驤Мх靭遠煬査TRUE聆FALSE禺拖A焯樿客聆焯樿と毚淆┛苓∠焯樿客聆と毚淆A禺∠愛FALSE＄細NOT砂閻泭背TRUE;苓∠焯樿客聆と毚淆A禺∠愛TRUE＄畬梓NOT砂閻泭背A禺∠愛FALSE┛奬掛

苓∠A1=6┚A2=8＄畬梓梧淆49澐

腑│尻閻шA黃竚Мх焯樿客愛13餒昌泭背毗

尻閻

Logical1＄logical2＄...驤蝝?洯がぅ'19A1厫30х焯樿と毚淆＄交禺拖再埼愛TRUE聆FALSE┛苓∠閻氈聆淅49A尻閻繍牲陷┥┚閻垓聆ぁt鋤舷?＄壟凹岌グ瑣j┛苓∠薜奘A準平шЩ繍牲焯樿客＄OR砂閻岌泭背園氅#value!┛奬掛

苓∠A1=6┚A2=8＄細梧淆9=(A1+A2>A2A1=A2):泭背TRUE;澘梧淆9=(A1>A2＄A1=A2):泭背切R月49澐

泭背焯樿客毗

尻閻

檔砂閻Щ蝝?尻奬掛

苓∠板A1鋤舷?坑橺午梧淆9=TRUE()背??據(jù)昌靭泭背TRUE┛朅板鋤舷?聆梧淆ш橺午陷垓TRUE＄Excel科勈蒔岌壟??耜焯樿客TRUETRUE挨?49引Ъ交壟62壞と?ゆ檣公婪┛令.件司49澐

泭背昻М淅49準平A朿Цこ?鋤舷?A?淆┚拐響聆坑婪4鑑皖＄檔砂閻挨?49引観薨Ъ交壟62壞と?ゆ檣A公婪畧毗

jinfo_typeш腑薜奘A鑑皖岌泭背縵龜據(jù)齣鎬A鋤舷?奬掛

梧淆9=EL("ro"＄A20):泭背20＄苓∠A3鋤舷?繍牲TOTAL＄細CELL("contents"＄A3)泭背工.司RROR.切同P49澐

泭背尹櫂引昻М園氅+鰭A閻垓＄苓∠á│園氅細泭背#N/A┛板IF砂閻ш靭遠角49ERROR.TYPEぅ\園氅客＄槭泭

P尻閻

Error_val愛蝝?煬咋交閻垓苑ラAМх園氅+鰭┛巫ゑerror_val靭遠驤奬盫A園氅客＄廻壟?棗愛Мх鋤舷?淅49＄澘泭背泭背泭背泭背泭背6＄#N/A泭背7＄交延園氅細泭背奬掛

苓∠A5=36/0＄細梧淆9=E.TPE(A5):泭背左49澐

泭背│醐澀曬迸凱ソ箕AA鑑皖毗

pe_tet驤М?泭背A鑑皖+ш"dirctor"A"email"49A坑垠ぁ浡(遠垓弜愛鋤拐)＄"meused"泭背閻蟾嘗49A坑垠ぁ浡＄"numfle"泭背澀曬腑│膰浤A朮凱とA閻ム＄"osersion泭背澀曬迸凱a聰A?┥吹(陷┥)"recc"泭背澀曬A脬嶤ょ靜淆99曳朮)"relas"EcelA?┥吹(陷┥)"stem"泭背迸凱a聰雛に(acintoshacWndospco")＄"ttmm"49A坑垠ぁ浡(遠垓弜愛鋤拐)┛B竚:INFO砂閻шA陷┥尻閻犲普49?陷淅吹淅奬掛

梧淆9=IF"osersin"):泭背9Windows(32-bit)490:＄=IF(mmaai)泭 4.I分49澐

交ш繍蓴49?ぅ'19閻客聆淅49+鰭A杏х朮凱と砂閻┛壟凹靭遠ぅ'19閻客A+鰭槭謬蟾尻閻A客泭背TRUE掛苓＄閻客愛ぁt鋤舷?淅49餒＄ISBLANK砂閻泭背焯樿客TRUE＄晴細泭背ISBLANK(value)ISERR(value)ISERROR(value)ISLOGICAL(value)ISNA(value)ISNONTEXT(value)ale驤蝝?'19At(ぁt鋤舷?)49客聆尹引遠ЦA雛に淅49┛苓∠砂閻шA尻閻愛Ч蹩A坑婪＄細泭背E:ISBLAKA尻閻驤ぁt鋤舷?＄ISERA尻閻驤黃竚園氅客(硾織#/A)＄ISERA尻閻驤黃竚園氅客(#/A#alu!#E!#V/!#!#AE?聆#UL!)ISLIALAISAA尻閻驤園氅客#/AISNETA尻閻驤黃竚Щ驤陷┥A坑婪(繒砂閻板客愛ぁt鋤舷?餒泭背E)ISNUBERA尻閻驤閻垓＄ISEFA尻閻驤淅49＄ISETA尻閻驤陷┥┛B竚:IS+砂閻A尻閻value驤Щ靭棤雖A┛板交延絡(luò)沃閻蝝?閻垓A砂閻ш＄陷┥"19"科グ棤雖耜閻垓19┛ケ澘板梧淆ISNUMBER("19")ш＄"19"槭58陷┥客棤雖耜交延+鰭A客＄澘驤泭背FALSE┛IS+砂閻49引ぅ'19梧淆嶤ょ禺∠順再│49＄壟Ъ砂閻IF禺崇板М??靭遠觸轄М?板梧淆ш薯査園氅客A靜奬掛

梧淆9=ISLAK(:泭背FALSE＄=ISREF(A5)泭背TRUE(交шa5愛ぁt鋤舷?)┛苓∠蝝?嶤ょA1:A4準平A樅批客＄廻Щ幔?奘鋤舷?坑驤晴繍牲閻垓＄細梧AVERAGE(A1:A4)泭背園氅客#DIV/0┛愛芋櫂掩洧?磚荒＄靭遠角49梧淆I分司有司49澐

\栝尻閻A溜峽畧＄苓∠尻閻愛峽閻泭背TRUE＄晴細泭背毗

Number炸\栝A閻客┛苓∠尻閻客Щ驤濶閻＄細勈蒔肭織峅閻瞟再神濶B竚:檔砂閻犲普爾榺9再?朮佼櫃:靜幔角49┛苓∠尻閻numberЩ驤閻客＄ISEVEN砂閻泭背園氅客#value!┛奬掛

梧淆9=ISEVEN(11)泭背FALSE:＄=ISEVE()泭背TRUE┛I分O49澐

\栝尻閻A溜峽畧＄苓∠尻閻愛溜閻泭背TRUE＄晴細泭背毗

尻閻

Number炸\栝A閻客┛苓∠尻閻Щ驤濶閻＄細勈蒔肭織峅閻瞟再神濶┛奬掛

梧淆9=IS(19:泭背TRUE＄=ISODD(14.5)泭背N49澐

泭背棤充愛閻客據(jù)A客毗

尻閻

value愛?棤充A客┛砂閻N靭遠棤充Чと祭査A客:閻垓泭背檔閻垓＄顫┘泭背檔顫┘A檣祭吹＄TRUE泭背泭背0＄園氅客(苓#DIV/0!)泭背檔園氅客＄交延客泭背奬掛

苓A1繍牲"7"＄A2繍牲"陷王"＄A3繍牲"TRUE"＄細梧淆9=N(A1)7＄=N(A2)泭背0(輩愛A2牲│陷垓)＄=N(A3)泭背1(輩愛A3牲│TRUE)┛49澐

泭背園氅客#N/A┛#N/Aと?9頷/煬咋│鐔客┛苓∠角49#N/A辿猯ぁt鋤舷?＄靭遠珺孤Щ峅犧岌ぁt鋤舷?嶤ょ坑澘欝40A汒??＄輩愛梧淆淅49牲│#N/AA鋤舷?餒泭背園氅客#N/A┛尻閻

ぁt鋤舷奬掛

梧淆9=A(:泭背切同P49澐

泭背閻客A+鰭┛澀昻Мх砂閻A嶤ょ禺∠神膏引ゐ奘鋤舷?ш閻客A+鰭餒＄靭角49砂閻毗

尻閻

value靭遠驤ExcelшA閻蟾＄苓閻垓┚陷┥┚焯樿客苓value愛閻垓泭背1＄驤陷┥泭背2＄焯樿客泭背4＄園氅客泭背16＄閻氈泭背64┛奬掛

苓∠A1繍牲陷┥"腩璽"＄細梧淆9=PE(A1):泭背2┛=TYPE(2+A1)泭背令.A件件RIN49澐

泭背奘┘掩皖│翁斝錯A櫂嶤咲皖毗/

AI(isse＄frst_nterst＄settlement＄rate＄par＄frequency＄尻閻

Issue愛│翁斝錯A浸が顫＄First_interest驤斝錯A??皖顫＄Settlement驤斝錯A耜渦顫(昌浸が顫扱據(jù)斝錯除縵亝移隻A顫┘)＄Rate愛│翁斝錯A榱皖?咲ぬ＄Par愛│翁斝錯A?蹩翁客(苓∠水jpar＄砂閻ACCRINT岌par01凱$1000)＄Frequency愛榱掩皖澈閻(苓∠蕾榱錣掩＄frequency=1;蕾署榱┘錣掩＄frequency=2;蕾埖錣掩＄frequency=4)┛工.A件件RIN切49澐

泭背咋┘М澈畧掩皖│翁斝錯A櫂嶤咲皖毗/

AIT(issu＄matuit＄rate＄尻閻

Issue愛│翁斝錯A浸が顫＄Maturity愛│翁斝錯A咋┘顫＄Rate愛│翁斝錯A榱皖?咲ぬ＄Par愛│翁斝錯A?蹩翁客Basis愛顫嶤閻娩剛+鰭(0聆水j餒愛30/360＄1愛奬盫酪閻/奬盫酪閻＄2愛奬盫酪閻/360＄3愛奬盫酪閻/365＄4愛炅￠左.AMOR號司出R49澐

泭背馞х科嶤┘浡A茉顰客毗

尻閻

Cost愛俒欝丞客＄Date_purchased愛亝午俒欝A顫┘＄First_period愛?Мх┘浡禺?餒A顫┘＄Salvage愛俒欝板角49屏遷禺?餒A郞客＄Period驤┘浡＄Rate愛茉顰ぬ＄Basis驤腑角49A榱娩剛(0聆水j餒愛360酪＄1愛奬盫酪閻＄3愛М榱365酪＄4愛М榱360酪)┛AMORLIN49澐

泭背馞х科嶤┘浡A茉顰客＄檔砂閻愛/迫科嶤a聰觸轄┛苓∠昻旡俒欝驤板科嶤┘浡坑亝午A＄細蕾楫畧茉顰/嶤ょ毗

榱件O月P號A同B49澐

泭背澀曬掩皖┘坑肭綠咋耜渦顫A酪閻毗

尻閻

Settlement驤斝錯A耜渦顫(昌浸が顫扱據(jù)斝錯除縵亝移隻A顫┘)＄Maturity愛│翁斝錯A咋┘顫＄Frequency愛榱掩皖澈閻(苓∠蕾榱錣掩＄frequency=1;蕾署榱┘錣掩＄frequency=2;蕾埖錣掩＄frequency=4)＄Basis愛顫嶤閻娩剛+鰭(0聆水j30/360＄1愛奬盫酪閻/奬盫酪閻＄2愛奬盫酪閻/360＄3愛奬盫酪閻/365＄4愛炅￠30/360)┛件O月P號A同49澐

泭背耜渦顫腑板A掩皖┘A酪閻毗

尻閻

Settlement驤斝錯A耜渦顫(昌浸が顫扱據(jù)斝錯除縵亝移隻A顫┘)＄Maturity愛│翁斝錯A咋┘顫(昌│翁斝錯│鐔┘肭綠餒A顫┘)＄Frequency愛榱掩皖澈閻(苓∠蕾榱錣掩＄frequency=1;蕾署榱┘錣掩＄frequency=2;蕾埖錣掩＄frequency=4)＄Basis愛件O月P號A同分N49澐

泭背閲耜渦顫咋ЧМ掩皖顫扱浡A酪閻毗

尻閻

Settlement驤斝錯A耜渦顫＄Maturity愛│翁斝錯A咋┘顫＄Frequency愛榱掩皖澈閻(苓∠蕾榱錣掩＄frequency=1;蕾署榱┘錣掩＄frequency=2;蕾埖錣掩＄frequency=4)＄Basis愛顫嶤閻娩剛+鰭(0聆水j愛30/360＄1愛奬盫酪閻/奬盫酪閻＄2愛奬盫酪閻/360＄3愛奬盫酪閻/365＄4愛炅￠30/360)┛件O月PN月49澐

泭背耜渦顫塑咋┘顫扱浡A咲皖櫂掩澈閻＄菅Ц神濶咋龜?A濶閻毗/

P(settlementmatrit＄freuec＄bass)尻閻

趨Ц件O月PP49澐

49澐

泭背耜渦顫扱曬AЦМ掩皖顫A顫毗/

PP(setteent＄aturit＄frqunc＄bsis)尻閻

趨Ц令代.件月MIPM49澐

泭背Мマ佤琪板縵奘Astart-period咋end-period┘浡T嶤況洦A咲皖閻璽毗

P尻閻

Rate愛咲ぬ＄Nper愛疽掩琪┘閻＄Pv愛タ客＄Start_period愛嶤ょшA?┘(掩琪┘閻閲1浤丐嶤閻)＄End_period愛嶤ょшA┤┘＄Type愛掩琪餒浡+鰭(0(蕝)愛┘┤掩琪＄1愛┘際掩琪)┛令令.件月MPRIN49澐

泭背Мマ佤琪板縵奘Astart-period咋end-period┘浡T嶤況洦A┥腩閻璽毗

尻閻

Rate愛咲ぬ＄Nper愛疽掩琪┘閻＄Pv愛タ客＄Start_period愛嶤ょшA?┘(掩琪┘閻閲1浤丐嶤閻)＄End_period愛嶤ょшA┤┘＄Type愛掩琪餒浡+鰭(0(蕝)愛┘┤掩琪＄1愛┘際掩琪)┛令工.號49澐

角49粕奘開璽潠麹/＄嶤ょМマ俒欝板縵奘┘浡坑A茉顰客毗

尻閻

Cost愛俒欝丞客＄Salvage愛俒欝板茉顰┘┤A翁客(伊に愛俒欝郞客)＄Life愛茉顰┘睊(│餒伊に凱俒欝A角49屏遷Period愛蝝?嶤ょ茉顰客A┘浡┛Period犲普角49Ъlifeロ趨A鋤拐＄Month愛?М榱A━沖閻(水j餒弓擄愛令左.號號49澐

角49振毅開璽潠麹/聆交延薜奘靜/＄嶤ょМマ俒欝板縵奘┘浡坑A茉顰客毗

尻閻

Cost愛俒欝丞客＄Salvage愛俒欝板茉顰┘┤A翁客(伊に愛俒欝郞客)＄Life愛茉顰┘睊(│餒伊に凱俒欝A角49屏遷Period愛蝝?嶤ょ茉顰客A┘浡┛Period犲普角49Ъlifeロ趨A鋤拐＄Factor愛開璽潠麹濼ぬ(苓∠factor水j＄細弓擄愛令4.號I49澐

泭背│翁斝錯A仱タぬ毗

尻閻

Settlement驤斝錯A耜渦顫(昌板浸が顫扱據(jù)＄斝錯除縵亝移隻A顫┘)＄Maturity愛│翁斝錯A咋┘顫＄Pr愛蹩客$100│翁斝錯A翁?＄Redemption愛蹩客$100A│翁斝錯A《況翁客＄Basis愛顫嶤閻娩剛+鰭(0聆水j愛30/360＄1愛奬盫酪閻/奬盫令5.號OLLAR號49澐

岌蕾再閻と?A翁?棤雖愛蕾峅閻と?A翁?＄苓斝錯翁?＄棤雖愛峅閻と?A閻垓毗

尻閻

Fractional_dollar遠再閻と?A閻垓＄Fraction再閻шA再餧(濶閻令6.號49澐

岌蕾峅閻と?A翁?棤雖愛蕾再閻と?A翁?毗

尻閻

Decimal_dollar愛峅閻＄Fraction再閻шA再餧(濶閻令7.號月RA切49澐

泭背弓擄蹩客$100A奘┘掩皖│翁斝錯A癌緖┘睊┛┘睊奘圧愛Мa(chǎn)祭タ腩êタ客A爾┼樅批客＄49引嶤脽黍錯翁?尹鍮ゐぬ紳充A鐵笨ゆ欸毗

尻閻

Settlement驤斝錯A耜渦顫＄Maturity愛│翁斝錯A咋┘顫＄Coupon愛│翁斝錯A榱皖?咲ぬ＄Yld愛│翁斝錯A榱鍮ゐぬ＄Frequency愛榱掩皖澈閻(苓∠蕾榱錣掩＄frequency=1;蕾署榱┘錣掩＄frequency=2;蕾埖錣掩＄frequency=4)＄Basis顫嶤閻娩+鰭(0聆水j愛30/360＄1愛奬盫酪閻/奬盫酪閻＄2愛奬盫酪閻/360＄3愛奬盫酪閻/365＄4愛炅￠令8.司FF司件49澐

咲49縵奘A雛圧榱咲ぬ塑М榱шA羊咲┘澈＄嶤ょ奬盫榱咲ぬ毗

尻閻

Nominal_rate愛雛圧咲ぬ＄Npery愛馞榱A羊咲┘閻令9.F49澐

娩引粕奘咲ぬ心4璽再┘掩琪靜淆＄泭背昻旡苞俒A┣?客毗

尻閻

Rate愛錘┘咲ぬ＄Nper愛疽苞俒┘(昌檔旡苞俒A掩琪┘疽閻)＄Pmt愛錘┘腑櫂錣掩A腩璽＄Pv愛タ客(昌閲檔旡苞俒浤工代.F有分件擊司號月L49澐

娩引Мa(chǎn)祭羊咲泭背┥腩A┣?客＄49引嶤ょ昻旡苞俒板紳蒔聆靭潾咲ぬЧA毗

尻閻

Principal愛タ客＄Schedule愛咲ぬ閻氈工令I(lǐng)切RA切49澐

泭背М澈畧掩皖斝錯A咲ぬ毗

尻閻

Settlement驤斝錯A耜渦顫＄Maturity愛│翁斝錯A咋┘顫＄Investment愛│翁斝錯A苞俒璽＄Redemption愛│翁斝錯咋┘餒A《況翁客＄Basis顫嶤閻娩剛+鰭(0聆水j愛30/360＄1愛奬盫酪閻/奬盫酪閻＄2愛奬盫酪閻/360＄3愛奬盫酪閻/365＄4愛炅￠30/360)┛工工IM49澐

娩引粕奘咲ぬ心4璽再┘掩琪靜淆＄泭背苞俒聆佤琪板昻М縵奘┘睊坑A咲皖況洦璽毗

尻閻

Rate愛錘┘咲ぬ＄Per49引嶤ょ交咲皖閻璽A┘閻(1nper扱浡)＄Nper愛疽苞俒┘＄Pv愛タ客(┥腩)＄Fv愛┣?客(龜據(jù)М澈掩琪據(jù)Aタ腩開璽┛苓∠水jfv＄細弓擄交客愛蕝)＄Type薜奘錘┘A掩琪餒浡驤板┘際洦驤┘┤(0愛┘┤＄1愛┘際)┛工左49澐

泭背58閻客苑とAМ氈タ腩êA坑瞟鍮ゐぬ毗

尻閻

values愛閻氈聆鋤舷?A淅49＄繍牲49?嶤ょ泭背A坑瞟鍮ゐぬA閻垓┛Guess愛尹砂閻IRR嶤ょ禺∠A迦嶤客工I分PM49澐

嶤ょゐ奘苞俒┘坑?錣掩A咲皖毗

尻閻

Rate愛苞俒A咲ぬ＄Per愛?嶤ょ咲皖A┘閻(板1咋nper扱浡)＄Nper愛苞俒A疽錣掩┘閻＄Pv愛苞俒A澀曬客(尹引佤琪?洱pv愛佤琪閻璽)┛工5.M號月RA切49澐

泭背弓擄蹩客$100A│翁斝錯AMacauley癌緖┘睊毗

A尻閻

Settlement驤斝錯A耜渦顫＄Maturity愛│翁斝錯A咋┘顫＄Coupon愛│翁斝錯A榱皖?咲ぬ＄Yld愛│翁斝錯A榱鍮ゐぬ＄Frequency愛榱掩皖澈閻(苓∠蕾榱錣掩＄frequency=1;蕾署榱┘錣掩＄frequency=2;蕾埖錣掩＄frequency=4)＄Basis顫嶤閻娩+鰭(0聆水j愛30/360＄1愛奬盫酪閻/奬盫酪閻＄2愛奬盫酪閻/360＄3愛奬盫酪閻/365＄4愛炅￠工49澐

泭背昻М┘睊坑タ腩êA癌緖坑瞟鍮ゐぬ毗

aus愛МхA鋤舷?A淅49(苑と46錘┘AМa(chǎn)ш犲普厫峇繍牲Мх緖客塑Мх麯客＄膕幔嶤ょ癌緖據(jù)A坑瞟鍮ゐぬ)＄Finace_ate愛タ腩êш49A俒腩錣掩A咲ぬ＄einet_rate愛岌タ腩ê巷苞俒A工49澐

娩引縵奘A奬盫咲ぬ塑榱羊咲┘閻＄泭背雛圧榱咲ぬ毗

尻閻

Effect_rate愛奬盫咲ぬ＄Npery愛馞榱A羊咲┘閻工8.NP司49澐

娩引粕奘咲ぬ心4璽再┘掩琪靜淆＄泭背昻旡苞俒(聆佤琪)A疽┘閻毗

Type靭遠薜奘錘┘A掩琪餒浡驤板┘際洦驤┘┤(0愛┘┤＄1愛┘際工9.NP49澐

?汍角49仱タぬ遠心Мa(chǎn)祭┣?錣査(麯客)塑鍮午(緖客)＄泭背М旡苞俒A閤タ客毗

愛咋左代.O號號FPRI49澐

泭背?┘掩皖顫Щ粕奘A蹩客$100A│翁斝錯A翁?毗

尻閻

Settlement愛斝錯A耜渦顫＄Maturity愛│翁斝錯A咋┘顫＄Issue愛│翁斝錯A浸が顫＄First_coupon愛│翁斝錯┘掩皖顫＄Rate愛│翁斝錯A咲ぬ＄Yld愛│翁斝錯A榱鍮ゐぬ＄Redemption愛蹩客$100A│翁斝錯A《況翁客＄Frequency愛榱掩皖澈閻(苓∠蕾榱錣掩＄frequency=1;蕾署榱┘錣掩＄frequency=2;蕾埖錣掩＄frequency=4)＄Basis愛顫嶤閻娩剛+鰭(0聆水j愛30/360＄1愛奬盫酪閻/奬盫酪閻＄2愛奬盫酪閻/360＄3愛奬盫酪閻/365＄4愛炅￠30/360)┛左令.O號號F同I司L49澐

泭背?┘掩皖顫Щ粕奘A│翁斝錯(懜┘聆テ┘)A鍮ゐぬ毗

尻閻

Settlement驤斝錯A耜渦顫＄Maturity愛│翁斝錯A咋┘顫＄Issue愛│翁斝錯A浸が顫＄First_coupon愛│翁斝錯┘掩皖顫＄Rate愛│翁斝錯A咲ぬ＄Pr愛│翁斝錯A翁?＄Redemption愛蹩客$100A│翁斝錯A《況翁客＄Frequency愛榱掩皖澈閻(蕾榱錣掩＄frequency=1;蕾署榱┘錣掩＄frequency=2;蕾埖錣掩＄frequency=4)＄Basis愛顫嶤閻娩剛+鰭(0聆水j愛30/360＄1愛奬盫酪閻/奬盫酪閻＄2愛奬盫酪閻/360＄3愛奬盫酪閻/365＄4愛炅￠30/360)┛左工.O號號LPRI49澐

泭背┤┘掩皖顫Щ粕奘A蹩客$100A│翁斝錯(懜┘聆テ┘)A翁?毗

尻閻

Settlement愛│翁斝錯A耜渦顫＄Maturity愛│翁斝錯A咋┘顫＄Last_interest愛│翁斝錯A┤┘掩皖顫＄Rate愛│翁斝錯A咲ぬ＄Yld愛│翁斝錯A榱鍮ゐぬ＄Redemption愛蹩客$100A│翁斝錯A《況翁客＄Frequency愛榱掩皖澈閻(苓∠蕾榱錣掩＄frequency=1;蕾署榱┘錣掩＄frequency=2;蕾埖錣掩＄frequency=4)＄Basis愛顫嶤閻娩剛+鰭(0聆水j愛30/360＄1愛奬盫酪閻/奬左左.O號號L同I司L49澐

泭背┤┘掩皖顫Щ粕奘A│翁斝錯(懜┘聆テ┘)A鍮ゐぬ毗

尻閻

Settlement驤斝錯A耜渦顫＄Maturity愛│翁斝錯A咋┘顫＄Last_interest愛│翁斝錯A┤┘掩皖顫＄Rate愛│翁斝錯A蕾署榱┘錣掩＄frequency=2;蕾埖錣掩＄frequency=4)＄Basis愛顫嶤閻娩剛+鰭(0聆水j愛30/360＄1愛奬盫酪閻/奬盫酪閻＄2愛奬盫酪閻/360＄3愛奬盫酪閻/365＄4愛炅￠30/360)┛左.49澐

娩引粕奘咲ぬ心4璽再┘掩琪靜淆＄泭背佤琪A馞┘掩琪璽毗

尻閻

Rate佤琪咲ぬ＄Nper檔旡佤琪A掩琪疽閻＄Pv愛タ客(伊に愛┥腩)＄Fv愛┣?客(聆龜據(jù)М澈掩琪據(jù)栞└煬咋Aタ腩開左5.PPM49澐

娩引粕奘咲ぬ心4璽再┘掩琪靜淆＄泭背苞俒板昻М縵奘┘浡坑A┥腩況洦璽毗

尻閻

Rate愛錘┘咲ぬ＄Per49引嶤ょ交┥腩閻璽A┘閻(悅引1咋nper扱浡)＄Nper愛疽苞俒┘(檔旡苞俒A掩琪┘疽閻)＄Pv愛タ客(伊に愛┥腩)＄Fv愛┣?客＄Type薜奘錘┘A掩琪餒浡驤板┘際洦驤┘┤(1愛┘際┛0愛┘┤)┛左6.PRI件49澐

泭背奘┘掩皖A蹩客$100A│翁斝錯A翁?毗

尻閻

Settlement驤斝錯A耜渦顫＄Maturity愛│翁斝錯A咋┘顫＄Rate愛│翁斝錯A榱皖?咲ぬ＄Yld愛│翁斝錯A榱鍮ゐぬ＄4愛炅￠30/360)┛左7.PRI件司號I49澐

泭背茉翁浸がA蹩客$100A│翁斝錯A翁?毗

尻閻

Settlement驤斝錯A耜渦顫＄Maturity愛│翁斝錯A咋┘顫＄Discount愛│翁斝錯A仱タぬ＄Redemption愛蹩客$100│翁斝錯A《況翁客＄Basis愛顫嶤閻娩剛+鰭(0聆水j30/360＄1愛奬盫酪閻/奬盫酪閻＄2愛奬盫酪閻/360＄3愛奬盫酪閻4愛炅￠左8.PRI件司MA49澐

泭背咋┘掩皖A蹩客$100A│翁斝錯A翁?毗

尻閻

Settlement愛斝錯A耜渦顫＄Maturity愛│翁斝錯A咋┘顫＄Issue愛│翁斝錯A浸が顫(遠餒浡檣祭吹と?)＄Rate愛│翁斝錯板浸が顫A咲ぬ＄Yld愛│翁斝錯A榱鍮ゐぬ＄Basis愛顫嶤閻娩剛+鰭(0聆水j愛30/360＄1愛奬盫酪閻/奬盫酪閻＄2愛奬盫酪閻/360＄3愛奬盫酪閻/365＄4愛炅￠30/360)┛左9.P49澐

泭背苞俒Aタ客(昌Мa(chǎn)祭┣?掩琪A澀曬客ATな塑)＄苓亀午靜A亀午琪昌愛佤査靜佤琪Aタ客毗

尻閻

Rate愛錘┘咲ぬ＄Nper愛疽苞俒(聆佤琪)┘閻＄Pmt愛錘┘腑櫂錣掩A腩璽＄Fv愛┣?客＄Type薜奘錘┘A掩琪餒浡驤板┘際洦驤┘┤(1愛┘際┛0愛┘┤)┛4代.RA49澐

泭背榱腩A錘┘咲ぬ┛砂閻RATE?汍淂苑/嶤ょ煬査＄槭а靭幔頷?聆│沃х?毗

尻閻

Nper愛疽苞俒┘(昌檔旡苞俒A掩琪┘疽閻)＄Pmt愛錘┘掩琪璽＄Pv愛タ客(┥腩)＄Fv愛┣?客＄Type薜奘錘┘A掩琪餒浡驤板┘際洦驤┘┤(1愛┘際┛0愛┘┤)┛4令.R司件司I有司49澐

泭背М澈畧掩皖A│翁斝錯咋┘鍮背A腩璽毗

尻閻

Settlement愛斝錯A耜渦顫＄Maturity愛│翁斝錯A咋┘顫＄Investment愛│翁斝錯A苞俒璽＄Discount愛│翁斝錯A仱4工.分49澐

泭背昻旡俒欝板Мх┘浡шA楫畧茉顰客毗

尻閻

Cost愛俒欝丞客＄Salvage愛俒欝板茉顰┘┤A翁客(伊に愛俒欝郞客)＄Life愛茉顰┘睊(│餒伊に凱俒欝A角49屏遷4左.分同49澐

泭背昻旡俒欝蕾榱睊疽塑茉顰/嶤ょA薜奘┘浡A茉顰客毗

尻閻

Cost愛俒欝丞客＄Salvage愛俒欝板茉顰┘┤A翁客(伊に愛俒欝郞客)＄Life愛茉顰┘睊(│餒伊に凱俒欝A角49屏遷Per愛┘浡(鋤拐Ъlifeロ趨切BILL司49澐

泭背迫櫃錯A4鐔鍮ゐぬ毗

尻閻

Settlement愛迫櫃錯A耜渦顫(昌板浸が顫扱據(jù)＄迫櫃錯除縵亝移隻A顫┘)＄Maturity愛迫櫃錯A咋┘顫＄Discount愛迫切BILLPRI件49澐

泭背蹩客$100A迫櫃錯A翁?毗

尻閻

Settlement愛迫櫃錯A耜渦顫＄Maturity愛迫櫃錯A咋┘顫＄Discount愛迫櫃錯A仱タぬ切BILL同I司L49澐

泭背迫櫃錯A鍮ゐぬ毗

尻閻

Settlement愛迫櫃錯A耜渦顫＄Maturity愛迫櫃錯A咋┘顫＄Pr愛蹩客$100A迫櫃錯A翁?有號49澐

角49振毅開璽潠麹/聆交延薜奘A靜/＄泭背薜奘A黃皆┘浡坑(繍蓴瞟再┘浡)A俒欝茉顰客毗

尻閻

Cost愛俒欝丞客＄Salvage愛俒欝板茉顰┘┤A翁客(伊に愛俒欝郞客)＄Life愛茉顰┘睊(│餒伊に凱俒欝A角49屏遷Start_period愛洯が茉顰嶤ょA??丐┘浡＄End_period愛洯が茉顰嶤ょA肭綠┘浡下49泭背М氈タ腩êA坑瞟鍮ゐぬ洧羽タ腩êЩМ奘奘┘浸40┛朅?嶤ょМ氈奘┘タ腩êA坑瞟鍮ゐぬ靭遠角49IRR砂閻毗

嶤ょ禺∠A迦嶤客下NP49澐

泭背М氈タ腩êA閤タ客＄洧羽タ腩êЩМ奘奘┘浸40┛朅?嶤ょМ氈奘┘タ腩êA閤タ客＄靭遠角49砂閻毗

5代.同I司L49澐

泭背奘┘掩皖│翁斝錯A鍮ゐぬ＄砂閻YIELD49引嶤ょ黍錯鍮ゐぬ毗

尻閻

Settlement驤斝錯A耜渦顫＄Maturity愛│翁斝錯A咋┘顫＄Rate愛│翁斝錯A榱皖?咲ぬ＄Pr愛蹩客$100A│翁斝錯A翁?＄Redemption愛蹩客$100A│翁斝錯A《況翁客＄Frequency愛榱掩皖澈閻(苓∠蕾榱錣掩＄frequency=1;蕾署榱┘錣掩＄frequency=2;蕾埖錣掩＄frequency=4)＄Basis愛顫嶤閻娩剛+鰭(0聆水j愛30/360＄1愛奬盫酪閻/奬盫酪閻＄2愛奬盫酪閻/360＄3愛奬盫酪閻/365＄4愛炅￠30/360)┛5令.同I司L號號I49澐

泭背茉翁浸がA│翁斝錯A榱鍮ゐぬ毗

尻閻

Settlement愛斝錯A耜渦顫＄Maturity愛│翁斝錯A咋┘顫＄Pr愛蹩客$100A│翁斝錯A翁?＄Redemption愛蹩客$100A│翁斝錯A《況翁客＄Basis愛顫嶤閻娩剛+鰭(0聆水j30/360＄1愛奬盫酪閻/奬盫酪閻＄2愛奬盫酪閻/360＄3愛奬盫酪閻/365＄4愛炅￠30/360)┛5工.同I司L號MA49澐

泭背咋┘掩皖A│翁斝錯A榱鍮ゐぬ毗

A尻閻

Settlement驤斝錯A耜渦顫＄Maturity愛│翁斝錯A咋┘顫＄Issue愛│翁斝錯A浸が顫(遠餒浡檣祭吹と?)＄Rate愛│翁斝錯板浸が顫A咲ぬ＄Pr愛蹩客$100A│翁斝錯A翁?＄Basis愛顫嶤閻娩剛+鰭(0聆水j愛30/360＄1愛奬盫酪閻/奬盫酪閻＄2愛奬盫酪閻/360＄3愛奬盫酪閻/365＄4愛炅￠30/360)┛令.B司分分司毗

尻閻

X愛尻閻客┛N愛砂閻A痗閻┛苓∠n蹍濶閻＄細肭已神濶工.B司分分司49澐

泭背Bessel砂閻客

左.B司分分司49澐

泭背癌緖Bessel砂閻客＄壟Ъ49巉?閻尻閻泂ょ餒ABessel砂閻客ロ

B司分分司L49澐

泭背Bessel砂閻客＄伊に愛Weber砂閻聆ann砂閻

I工號司49澐

岌因洯策閻棤雖愛順洯策閻毗

尻閻

Number炸棤雖A因洯策閻┛NumberA拐閻Щ幔沃引10拐(因洯策拐)＄龜'95拐愛ヰ吹拐＄據(jù)9拐愛閻垓拐┛麯閻49因洯I工擊司49澐

岌因洯策閻棤雖愛順檎洯策閻毗

＄尻閻

Number愛炸棤雖A因洯策閻┛NumberA拐閻Щ幔沃引10拐(因洯策拐)＄龜'95拐愛ヰ吹拐＄據(jù)9拐愛閻垓拐┛麯閻49I工O件49澐

岌因洯策閻棤雖愛悟洯策閻毗

m＄尻閻

Number愛炸棤雖A因洯策閻;ces愛腑?角49A垓ヰ閻件OMPL司49澐

岌奬a閻心?a閻棤雖愛x+yi聆x+yj澤淆A羊閻毗

E尻閻

Real_num愛羊閻A奬瞟＄I_num愛羊閻A?瞟＄Suffix愛羊閻ш?瞟A據(jù)醯＄水j餒細幞愛壟愛件ON有司R49澐

岌閻垓閲Мх欸脽a聰棤雖咋塵Мх欸脽a聰毗

尻閻

Number驤遠from_units愛鋤拐A蝝?洯が棤雖A閻客┛From_unit驤閻客numberA鋤拐┛To_unit驤禺∠A鋤拐令代.號司件工49澐

岌順洯策閻棤雖愛因洯策閻毗

m＄尻閻

Number驤炸棤雖A順洯策閻┛ces驤腑?角49A垓ヰ閻＄苓∠水jces＄砂閻DEC2OCT49幔と?繒閻A龜峇垓?と?令令.號司件工擊49澐

岌順洯策閻棤雖愛順檎洯策閻毗

m＄尻閻

Number愛炸棤雖A順洯策閻┛苓∠尻閻number驤麯閻＄細水j ces驤腑?角49A垓ヰ閻令工.號司件工O件49澐

岌順洯策閻棤雖愛悟洯策閻毗

m＄尻閻

Number愛炸棤雖A順洯策閻┛苓∠尻閻number驤麯閻＄細水j ces驤腑?角49A垓ヰ閻令左.號司L切49澐

\栝пх閻客驤晴ロ4┛苓∠number1=number2＄細泭背1＄晴細泭背毗

尻閻

Number1愛?Мх尻閻┛Number2愛?因х尻閻┛苓∠水j＄弓擄Number2A客愛蕝令4.司49澐

泭背氅杙砂閻板ЦЧ睊扱浡Aな再毗

jERF令5.司RF49澐

泭背閲x咋W(頷?)な再AERF砂閻A開氅杙砂毗

尻閻

X?驤ERF砂閻な再AЧ睊令6.出司分切司49澐

苓∠Number絡(luò)引4step1＄晴細泭背0┛角49檔砂閻靭が漊閻蟾毗

尻閻

Number驤炸\栝A閻客┛Step驤瀠客┛苓∠水jstep＄細砂閻GESTEP弓擄交愛蕝令7.擊司下工49澐

岌順檎洯策閻棤雖愛因洯策閻毗

＄尻閻

Number驤炸棤雖A順檎洯策閻＄ces驤腑?角49A垓ヰ閻令8.擊司下工號司49澐

岌順檎洯策閻棤雖愛順洯策閻毗

尻閻

Number驤炸棤雖A順檎洯策閻┛尻閻numberA拐閻Щ幔沃引10拐(40拐因洯策)＄龜'95拐愛ヰ吹拐＄交開39拐驤閻令9.擊司下工O件49澐

岌順檎洯策閻棤雖愛悟洯策閻毗

m＄尻閻

Number驤炸棤雖A順檎洯策閻＄ces驤腑?角49A垓ヰ閻工代IA49澐

泭背遠x+yi聆x+yj陷┥?淆と?A羊閻A聟尹客毗

尻閻

Inumber?愛蝝?嶤ょ交聟尹客A羊閻49澐

泭背遠x+yi聆x+yj陷┥?淆と?A羊閻A?a閻┛尻閻

Inumber?愛蝝?嶤ょ交?a閻A羊閻尻閻

Inumber愛49?嶤ょこ?欸客A羊閻49澐

泭背遠x+yi聆x+yj陷┥?淆と?A羊閻A誤棥羊閻┛尻閻

Inumber愛蝝?嶤ょ交誤棥閻A羊閻49澐

泭背遠x+yi聆x+yj陷┥?淆と?A羊閻A開湶┛尻閻

Inumber愛蝝?嶤ょ交開湶客A羊閻49澐

泭背遠x+yi聆x+yj陷┥?淆と?Aпх羊閻A淡┛尻閻

Inumber1愛羊閻再壞(グ硾閻)＄Inumber2愛羊閻再餧(硾閻49澐

泭背遠x+yi聆x+yj陷┥?淆と?A羊閻A薜閻┛尻閻

Inumber?愛蝝?嶤ょ交薜閻A羊閻49澐

泭背遠x+yi聆x+yj陷┥?淆と?A羊閻A勈ケ尹閻毗

尻閻

Inumber愛蝝?嶤ょ交勈ケ尹閻A羊閻49澐

泭背遠x+yi聆x+yj陷┥?淆と?A羊閻A棗49尹閻(遠10愛檸閻)┛尻閻

Inumber?愛蝝?嶤ょ交棗49尹閻A羊閻49澐

泭背遠x+yi聆x+yj陷┥?淆と?A羊閻A遠2愛檸閻A尹閻┛尻閻

Inumber愛蝝2愛檸閻A尹閻客A49澐

泭背遠x+yi聆x+yj陷┥?淆と?A羊閻An澈椡┛尻閻

Inumber愛蝝?嶤ょ交椡客A羊閻＄Number愛蝝?嶤ょA椡澈49澐

泭背遠x+yi聆x+yj陷┥?淆と?A2厫29х羊閻A按な┛尻閻

nuber1inmbr2＄;愛129х49?ロ按A羊閻49澐

泭背遠x+yix+yj陷┥?淆と?A羊閻A奬a閻┛尻閻

Inumber?愛蝝?嶤ょ交奬a閻A羊閻49澐

泭背遠x+yi聆x+yj陷┥?淆と?A羊閻A緖湶客┛尻閻

Inumber?愛蝝?嶤ょ交緖湶A羊閻49澐

泭背遠x+yi聆x+yj陷┥?淆と?A羊閻A樅靜謬┛尻閻

Inumber愛蝝?嶤ょ交樅靜謬A羊閻49澐

泭背遠x+yi聆x+yj陷┥?淆と?Aпх羊閻A杙┛尻閻

Inumber1驤グ麹(羊)閻＄Inumber2驤愛麹(羊)49澐

泭背遠x+yi聆x+yj陷┥?淆と?Aпх聆沃х羊閻A塑毗

U尻閻

Inumber1＄inumber2＄...愛1咋29х蝝?ロ爾A羊閻＄尻閻

Number驤炸棤雖A悟洯策閻

尻閻

Number?驤炸棤雖A悟洯策閻＄尻閻

Number驤炸棤雖A悟洯策閻

49澐:岌閻垓棤雖愛炅舷澤淆＄岌閻垓58炅舷澤淆棤雖愛炅ツ耜絶迫乇枸澤淆＄聆咲49炅舷凱愛ш浡乇枸岌閻垓58昻М炅ツ耜迫乇枸棤充愛塵М炅ツ耜絶迫乇枸A澤淆(Хこ?棤雖醐毗R(尻閻:mber愛?AA鋤舷?A淅49Source驤58Х垓餧氈耜A垓ヰээA鋤舷?A淅49＄檔垓ヰэ尹櫂引e?乇枸AISO苑ラ┛ENVET砂閻ш靭遠角49Ч祭乇枸苑ラ:迫娵/般娩┥乇枸鋤I分O苑魲咲/B司妾汲/L月牀牀迫47號司?08?08す魲摩司分//?峽?峽語I司竚絡(luò)脧I切焠焠語NL陵般陵般咲個A切繳磲複霪櫃P切懟懟語47栞牀萸固出R炅ツ耜絶炅R49澐:Ъ養(yǎng)瞟閻蟾e?浠褓＄閲朮凱と泂が薯??＄ケ據(jù)SQL.REQUEST岌薯??禺∠遠閻氈A澤淆泭背＄澘頷蝝洯が夥暗ゆ毗尻閻:Connection_string觸轄鑑皖＄苓閻蟾e?雛に┚49脛ID塑嫻ラ4┛Output_ref尹49引垠鏗夐濶A浠褓垓ヰэA鋤舷?A淅49┛Driver_prompt薜奘52蒔ゆ檣尹槏儲皆餒髣?遠心皆?漊旡靭49┛Column_names_logical薜?驤晴岌祭雛凱愛禺∠A?Мが泭背苓∠?岌祭雛凱愛禺∠A?Мが泭背＄浘岌檔尻閻擄響愛TRUE┛苓∠Щ蝝?岌祭雛泭背＄細擄響愛FALSE┛苓∠水jcolumn_names_logical＄細SQL.REQUEST砂閻Щ泭背祭雛┛薯艫Ъ淅4949澐

遠陷垓澤淆泭背尹朮凱ěш昻М鋤舷?A淅毗

尻閻

Row_num驤鋤舷?淅49ш角49Aが吹;Column_num驤鋤舷?淅49ш角49A祭辿;Abs_num薜馭泭背A淅49+鰭(1聆水j49逼淆┛苓A1TRUE聆水j＄砂閻ADDRESS泭背A1逼淆A淅49;苓A1FALSE＄砂閻ADDRESS泭背R1C1逼淆A49┛Sheet_et愛М陷┥＄薜馭凱愛養(yǎng)瞟淅49A朮凱とA雛に＄苓∠水jshet_tet＄細Щ角49黃皆朮凱とA雛に┛奬掛

梧淆9=AES(1＄4＄4＄1):泭背1┛

尻閻

Reference驤尹昻М鋤舷?聆鋤舷?準平A淅49＄伊靭遠淅49沃х準平B竚:苓∠蝝?岌込х淅49薜奘愛Мх尻閻＄細犲普49蓴吹蓴???＄遠孤Excel岌澟吹凱愛尻閻浡A再籝ヰ┛奬掛

梧淆9=AEAS(:b4):泭背1＄=AREAS((A1:A3＄A4:A6＄B4:B7＄A16:A18))泭背4┛49澐

靭遠謬蟾縵奘AD淅客＄閲沃毚29х炸漊尻閻ш漊査ロ櫂A客聆迸凱┛

尻閻

Index_num驤49?薜馭炸漊尻閻檣吹A(chǔ)客＄壟犲普驤1咋29扱浡A閻垓┚聆隻驤繍牲閻垓1咋29A梧淆聆鋤舷?49;value1＄value2＄...愛1咋29х閻客尻閻＄靭遠驤閻垓┚鋤舷?＄杰奘圧A雛に┚梧淆┚砂閻聆陷9=SU(A1:CHOOSE(3A10A20A30))Ъ4翁(輩愛CHOOSE(3＄A10＄A20＄A30)泭背A30)┛毗尻閻

Reference愛蝝?煬咋交祭辿A鋤舷?聆鋤舷?準平苓∠水jreference＄細弓奘砂閻COLUMN驤尹腑板鋤舷?A淅49┛苓∠reference愛Мх鋤舷?準平＄槭а砂閻COLUMN凱愛t樅閻氈橺午＄細COLUMN砂閻岌referenceшA祭辿遠t樅閻氈A澤奬掛

梧淆9=L(A3):泭背1＄=COLUMN(B3:C5)泭背

)尻閻

Array愛蝝?煬咋交祭閻A閻氈┚閻氈梧淆聆尹鋤舷?準平A淅奬掛

梧淆9=LS(B1:4):泭背2＄=COLUMNS({5＄4;4＄5})泭背49澐

板とA?が薯艫薜奘A閻客＄槭58繒泭背と?聆閻氈澀曬祭ш薜奘が擁A毗/

LKP(loku_alue＄tbl_arra＄ro_ine_num＄rang_lokp)尻閻

Lookup_value驤蝝?板閻蟾と?Мがш薯艫A閻客＄壟靭遠驤閻客┚淅49聆陷垓э;Table_array驤蝝?板交ш薯艫閻蟾閻蟾靭遠角49尹準平聆準平雛にA淅49＄Table_arrayA?МがA閻客靭遠驤陷┥┚閻垓聆焯樿客┛Row_index_numш炸泭背A淳篊客Aが檣吹┛Range_lookup愛М焯樿客＄薜馭砂閻HLOOKUP薯艫餒驤n?淳篊＄洦驤?賀淳篊49澐

裁洵Мх＄49遠膰浤垠謹板?聚┆璽得┚Intrant(Inernet)A交壟陷王┛毗/

PELIK(lin_ocaion＄fiedl_nme)Lik_octinAшA昻х齣愛佼灰AEecl朮凱と聆朮凱ěшゐ奘A鋤舷?聆遷雛準平＄聆驤薜菅Word陷幤шA52蒔得ЦA陷王＄聆驤Interet聆ItrantЦAL埞炬;Friendlnae愛鋤舷?ш髣?A嗃褓陷垓聆閻垓＄壟49袽帒髣?槭椏│Ч災楫┛苓∠水j芋Friendl_name＄鋤舷?嶬岌lin_lcaion髣?愛嗃褓┛奬掛

/"＄"52蒔扱娵")科板朮凱とш髣?陷┥952蒔扱娵:＄鋤沙壟昌靭浠褓 鋤沙壟靭遠膰浤DサЦAREADME.TXT陷王┛49澐

泭背と?聆準平шA閻客聆尹閻客A淅49┛砂閻INDEX()│п?澤淆:閻氈塑淅49┛閻氈澤淆?棗泭背閻客聆閻客閻氈;49澤淆?棗泭背淅毗/

INDEX(array＄row_num＄column_num)泭背閻氈ш薜奘A鋤舷?聆鋤舷?閻氈A閻客尻閻

Array愛鋤舷?準平聆閻氈棗閻;Row_num愛閻氈ш昻がAが檣吹＄砂閻閲檔が泭背閻客┛苓∠水jrow_num＄細犲普│column_num;Column_num驤閻氈ш昻祭A祭檣吹＄砂閻閲檔祭泭背閻客┛苓∠水jcolumn_num＄細犲普│row_num┛Reference驤尹Мх聆沃х鋤舷?準平A淅49＄苓∠愛淅49橺午МхЩ浠褫A漊奘準平＄犲普49蓴吹蓴???┛Area_num驤漊蒡淅49шAМх準平＄槭泭背檔準平шrow_numcolumn_numA渦審準平┛漊ш聆橺午A?Мх準平檣吹愛1＄?因х愛2＄遠繒+褥┛苓∠水jarea_num＄細INDEX砂閻角49準平1┛奬掛

苓∠A1=68┚A2=96┚A3=90＄細梧淆9IE(A1:A3＄1＄1):泭背68＄=INDEX(A1:A3＄1＄1＄1)泭背49澐

泭背58陷垓э薜奘A淅49┛繒砂閻わ昌尹淅49洯が嶤ょ＄槭髣?交坑婪┛澀蝝?齣鎬梧淆ш鋤舷?A淅49＄澘Щ齣鎬梧┥怤＄昌靭角49INDIRECT砂閻毗

jref_tet苓a1FALSE＄ref_textグ??愛R1C1-逼淆A淅49┛平(菅脽)ш薯艫閻客＄ケ據(jù)泭背?因х鋤が準平聆鋤祭準平шロ趨拐響A閻客;交閻氈澤淆板閻氈A?Мが聆?М祭薯艫薜奘A閻客ケ據(jù)泭背閻氈A龜據(jù)Мが聆龜據(jù)М祭шロ趨拐響A閻客毗/1(菅脽澤淆毗/2(閻氈澤淆尻閻1(菅脽澤淆):Lookup_value愛砂閻LOOKUP板?Мх菅脽ш腑?薯艫A閻客┛Lookup_value靭遠愛閻垓┚陷┥┚焯樿客聆尻閻2(閻氈澤淆):Lookup_value愛砂閻LOOKUP板閻氈ш腑?薯艫A閻客┛Lookup_value靭遠愛閻垓┚陷┥┚焯樿客聆繍牲閻客A雛に聆淅49┛苓∠砂閻LOOKUP艫Щ咋lookup_value＄細角49閻氈ш峅引聆4引lookup_valueA龜絡(luò)閻客┛Array愛繍牲陷┥┚B竚:Lookup_vectorA閻客犲普蕾渚檣袤祭＄晴細LOOKUP砂閻Щ幔泭背緖?A禺∠＄尻閻шA陷┥Щ準再絡(luò)峅昂9=LOOKUP(76A1:A4)3})泭背2┛角49MATCH砂閻┛毗

C尻閻

Lookup_value愛蝝?板閻蟾とш薯艫A閻客＄壟靭遠驤閻客(聆閻垓┚陷┥聆焯樿客)┚尹閻垓┚陷┥聆焯樿客A鋤舷?淅49┛Lookup_array驤靭幔繍牲腑?薯艫A閻客A浠褫鋤舷?準平＄Lookup_array靭遠驤閻氈聆閻氈淅49;Match_type愛閻垓-1┚0聆1＄壟洱馭Excel苓皆板lookup_arrayш薯艫lookup_value┛苓∠match_type愛1＄砂閻MATCH薯艫峅引聆4引lookup_valueA龜絡(luò)閻客┛苓∠match_type愛0＄砂閻MATCH薯艫4引lookup_valueA?Мх閻客┛苓∠match_type愛-1＄砂閻MATCH薯艫B竚:MATCH砂閻泭背lookup_arrayшム辿客A拐響＄澘Щ驤閻客┥怤┛苓∠match_type愛0аlookup_value奬掛

苓∠A1=68┚A2=76┚A3=85┚A4=90＄細梧淆=A(90＄A1:A5＄0):泭背3┛毗

尻閻

Reference驤凱愛球ぶ脽尻㈩aA淅49準平＄壟犲普驤鋤舷?聆ロ浠鋤舷?準平A淅49;Rows驤ロ尹引球ぶ脽尻㈩aA朿Цこ?鋤舷?＄Ц(Ч)球ぶAが閻┛苓∠角495凱愛尻閻Rows＄細洱馭ム辿淅49準平A朿Цこ?鋤舷?魲reference改5が┛が閻靭愛緖閻(苑と板??丐淅49AЧ靜)聆麯閻(苑と板??丐淅49AЦ靜);Cols驤ロ尹引球ぶ脽尻㈩aA朿Цこ?鋤舷?＄朿(酢)球ぶA祭閻┛苓∠角495凱愛尻閻Cols＄細洱馭ム辿淅49準平A朿Цこ?A鋤舷?魲reference蹜酢5祭┛祭閻靭愛緖閻(苑と板??丐淅49A酢??)聆麯閻(苑と板??丐淅49A朿??);Height驤?泭背A淅49準平Aが閻＄Height犲普愛緖閻;Width驤?泭背A淅49準平A祭閻＄Width犲普愛緖閻奬掛

苓∠A1=68┚A2=76┚A3=85┚A4=90＄細梧淆=S(FFSE(A1:A2＄2＄0＄2＄1)):泭背

WReference愛蝝?煬咋交が吹A(chǔ)鋤舷?聆鋤舷?準平奬掛

梧淆9=WA6:泭背6＄苓∠板C5鋤舷?ш橺午梧淆9=W():＄交嶤ょ禺∠愛尻閻

Array驤蝝?煬咋交が閻A閻氈┚閻氈梧淆聆尹鋤舷?準平A淅奬掛

梧淆9=W(A1A9):泭背9＄=ROWS({1＄2＄3;4＄5＄6;1＄2＄3})泭背49澐

閲錣薨COM勈蒔充Aゆ檣ш泭背奬餒閻蟾┛

尻閻

ProgID杰壽ナ板┥般嶤ょ┳ш＄甌汍B巧ACOM勈蒔充爾榺夥AProgID雛に＄檔雛に49淅吹淅???┛Server驤泂が爾榺夥A┆璽得A雛に┛苓∠á│┆璽得＄ゆ檣驤板┥般嶤ょ┳Ц泂が＄畬梓檔尻閻愛ぁt┛topc1＄tpi2＄...愛1咋28х尻閻＄洧49澐

泭背準平A棤響(A?Мが凱愛霰閻氈A?М祭＄閻氈A?因が凱愛霰閻氈A?因祭＄遠繒+褥)┛毗/

ASPSE(arra)┛尻閻

Array驤蝝?棤響A閻氈聆朮凱とшA鋤舷?準平奬掛

苓∠A1=68┚A2=76┚B1=85┚B2=90＄畬梓梧淆9{=ASPSE(A1:B1)}:泭背49とA?祭薯艫薜奘A58繒泭背と?聆閻氈澀曬がш薜奘祭擁A??客拐引閻蟾と?祭餒＄靭遠角49砂閻VLKP苑龕砂閻LKP┛毗

尻閻

Lookup_value愛蝝?板閻蟾と?М祭ш薯艫A閻客＄壟靭遠驤閻客┚淅49聆陷垓э┛Table_array愛蝝?板交ш薯艫閻蟾A閻蟾靭遠角49尹準平聆準平雛にA淅49┛Col_index_num愛table_arrayш炸泭背A淳篊客A祭檣吹┛Col_index_num愛1餒＄泭背table_array?М祭шA閻客;col_index_num愛2＄泭背table_array?因祭шA閻客＄遠繒+褥┛Range_lookup愛М焯樿客＄薜馭砂閻VLOOKUP泭背餒驤n?淳篊洦驤?賀淳篊┛苓∠愛TRUE聆水j＄細泭背?賀淳篊客＄伊嶬驤洱＄苓∠艫Щ咋n?淳篊客＄細泭背峅引lookup_valueA龜絡(luò)閻客;苓range_valueFALSE＄砂閻VLOOKUP岌泭背n?淳篊客┛苓∠艫Щ咋＄細泭背園奬掛

苓∠A1=23┚A2=45┚A3=50┚A4=65＄細梧淆=VLKP(50＄A1:A4＄1E):泭背閻堙塑Хこ?砂尻閻

number驤蝝?嶤ょ交聟尹客AМх奬閻奬掛

苓∠A1=-16＄細梧淆9=ABS(A1):泭背49澐

泭背遠湍欸と?A尻閻A新開湶客＄椑博驤0~征┛尻閻

number驤昻Мこ?欸A開湶客＄絡(luò)峅板-1Ｅ1扱浡奬掛

苓∠A1=0.5＄細梧淆9=AS(A1):泭背1. (昌征/3湍欸＄伊嶬驤600);澘梧淆9=ACOS(-0.5)10/PI():泭背120陣┛尻閻

number犲普絡(luò)引聆4引奬掛

梧淆9=AS(1:A嶤ょ禺∠4引0;9=AS(10):A嶤ょ禺∠4引尻閻

Number愛昻Мこ?欸A緖湶客＄交絡(luò)峅悅引-1Ｅ1扱浡奬掛

苓∠A1=-0.5＄細梧淆9=ASI(A1):泭背-0.5236(-征/6湍欸);澘梧淆9=ASIA1)180/PI():泭背-尻閻

number愛黃竚奬閻奬掛

梧淆9=ASINH(-5):泭背-1.6723;=ASI(0):泭背49澐

泭背尻閻AA閻客遠湍欸と?＄絡(luò)峅板-征/2Ｅ征/2毗/

AA(numer)尻閻

number愛昻Мこ?欸A緖最客┛苓∠?49欸と?泭背A新緖最客＄蝝岌禺∠按遠奬掛

梧淆9=AA(1)泭背0.785398(征/4湍欸);=ATAN(1)*180/PI()泭背49澐

泭背ラこ?緋辿a縵奘X心YA新緖最客┛壟4引X?Ъ汍丞88塑縵奘88(x_num＄y_num)Aラ楫扱浡A痢こ?＄槭悅引-毗

尻閻

X_num愛縵奘88AX緋辿＄Y_num愛縵奘88AY緋辿奬掛

梧淆9=AAN2(11)泭背0.785398(昌征/4湍欸);=ATAN2(-1＄-1)泭背-2.35619(-3征/4湍欸);=ATAN2(-1＄-泭背-49澐

泭背尻閻A新振齒緖最客＄尻閻犲普板-1Ｅ1扱浡(Щ繍蓴-11)┛

尻閻

number驤-奬掛

梧淆9=AA(05):泭背 ;=ATANH(-0.1)泭背-49澐

岌尻閻Number?聟尹客迷絡(luò)A靜菅＄泭背Мх龜褓?A濶閻聆娩閻significanceA龜峅毅閻┛尻閻

number愛炸泭背A閻客＄Significance愛炸泭背A龜峅毅閻B竚:頷拖numberA緖麯苓皆碝驤蕾洼《088A靜菅泭背禺∠┛苓∠number驤SignificanceA毅閻細泭背A閻客驤交勈怤┛奬掛

苓∠A1=3.1416＄細梧淆9=EILI(A1＄1)泭背A禺∠驤4;=CEILING(-2.5＄-2)泭背A禺∠愛Ｍ4┛毗

尻閻

number驤昻М尹絜A疽閻脽＄number_chosen細驤馞М氈崇ш尹絜A閻脽B竚:砂閻шA尻閻蕾㈩肭已神濶A丞細尻Ъ泂ょ＄槭а?|number>0┚number_chosen>0遠心number>number_chosen┛奬掛

弓擄│10雛鮎或29猋絶＄閲ш漊査黃竚п曳貅篊尻爾振膰＄細嶤ょ梧淆愛9=COBIN(102)靭遠煬査45?貅篊靜籾

尻閻

number愛蝝?開湶客AМхこ?欸＄犲普49湍欸と?┛苓∠numberA鋤拐驤欸＄靭遠按遠PI()/180棤雖愛湍欸奬掛

苓∠A1=1＄細梧淆9=S(A1):泭背0.540302;朅A2=60＄細梧淆9=S(API()/180):泭背尻閻

number愛黃竚奬閻奬掛

苓∠A1=5┚A3=6＄細梧淆9=S(A1+A3):泭背29937.07087;朅C1=60＄細梧淆9=S(S(1PI()/180)):背 尻閻

range愛蝝?聰嶤Aヰ崇?王A鋤舷?閻ムA準平;Criteria愛尻Ъ嶤ょA鋤舷??王交澤淆靭遠愛閻垓聆陷┥(36┚">160"塑"64"4)┛交ш閻垓靭遠ラ褓昂午＄と毚淆塑陷┥犲普爾淅吹奬掛

弓擄A1:A5準平坑垠鏗A陷┥再埼愛麟┚64┚麟┚64┚麟＄細梧淆9=COUNTIF(A1:A5＄"麟"):泭背毗

尻閻

angle驤?49湍欸鋤拐AМхこ?欸奬掛

梧淆9=EEES(1)泭背 :＄=EES(PI()/3)泭背

尻閻

number驤?神濶AМх閻客奬掛

苓∠A1=-2.6細梧淆9=EVE(A1):泭背-4;=EVEN(-4.56+6.87)泭背49澐

泭背eAn澈椡毗

尻閻

Number愛檸閻eA薜閻B竚:EXP砂閻驤嶤ょ勈ケ尹閻ALN砂閻A新砂閻奬掛

苓A1=3＄細梧淆9=EP(A1):泭背20.08553749澐

泭背Мх閻A痗按＄昌1*2*3*...*檔閻┛

B竚:Number驤嶤ょ交痗按A蹍麯閻┛苓∠橺午ANumberЩ驤濶閻＄細肭織峅閻瞟再神濶閻┛奬掛

苓A1=3＄細梧淆9=FA(A1):泭背6;=FACT(5.5)泭背1*2*3*4*5.5120┛49澐

泭背尻閻NumberA署痗按┛Number?嶤ょ交署痗按A閻客＄苓∠尻閻Number愛蹍濶閻＄細肭已神濶┛奬掛

梧淆9=FABLE(4):泭背49澐

岌尻閻Number?聟尹客麹峅A靜菅織已嘎午＄角交4引龜褓?AsignificanceA毅閻┛尻閻

Number愛?嘎午A昻М閻客＄Significance愛檔閻客A毅閻奬掛

苓∠A1=22.5＄細梧淆9=FL(A1＄1):泭背22;=FLOOR(-2.5＄-2)泭背-

尻閻

Number1＄number2＄...129х閻客＄苓∠閻客愛蹍濶閻＄細肭已神濶┛奬掛

苓∠A1=16┚A2=28┚A3=46＄細梧淆=(1:A3):泭背

尻閻

Number愛蝝?擁32A黃竚Мх奬閻奬掛

苓A1=16.24┚A2=-28.389＄細梧淆9=I(A1:泭背16＄=INT(A2)泭背-49澐

泭背濶閻A龜峅梧毅閻┛龜峅梧毅閻驤腑│濶閻尻閻nuber1nuber2┚＄A龜峅緖濶閻毅閻┛49砂閻LCM靭遠岌毗

尻閻

Number1＄number2＄...驤?嶤ょ龜峅梧毅閻A1咋29х尻閻┛苓∠尻閻Щ驤濶閻＄細勈蒔肭織峅閻瞟再神濶┛奬掛

苓∠A1=4┚A2=16┚A3=8＄細梧淆9=L(A1:A3):泭背49澐

泭背Мх閻A勈ケ尹閻＄昌遠e(2.71828182845904)愛檸A尹閻(LN砂閻驤EXP砂閻A新砂閻)┛

尻閻

Number驤炸嶤ょ交勈ケ尹閻A緖奬閻奬掛

苓∠A1=100┚A2=67＄細梧淆9=L(A1+2)泭背 ;=LN(EXP(3))泭背3;=EXP(LN(4))泭背尻閻

Number驤嶤ょ尹閻A黃竚奬閻＄Base驤尹閻A檸閻┛苓∠水j檸閻＄細棑幞壟A客愛奬掛

苓∠A1=8＄細梧淆9=L(A1＄2):泭背3;=LOG(100＄10)泭背49澐

泭背遠10愛檸A尹閻┛尻閻

Number驤炸嶤ょ棗49尹閻AМх緖奬閻奬掛

苓∠A1=1000＄細梧淆9=L10(A1):泭背3;=LOG10(10^5)泭背尻閻

Array驤Мхが祭閻ロ4A閻客閻氈┛Array靭遠驤鋤舷?準平＄掛苓A1:C3;聆驤Мх閻氈棗脽＄苓奬掛

苓A1=1┚A2=2┚B1=3┚B2=4＄細梧淆=EER(A1:B2):泭背-2┛尻閻

Array驤佼│ロ4が祭閻A閻客閻氈＄壟靭遠驤鋤舷?準平＄掛苓A1:C3;伊靭遠驤棗閻閻氈苓聆隻驤п隻A9=IVESE({4-1;20})0＄0.5;0.75＄-0.25＄-49澐

泭背п閻氈Aソ痌按な┛禺∠ソ痌Aが閻Ъarray1Aが閻ロ趨＄ソ痌A祭閻Ъarray2A祭閻ロ趨┛奬掛

梧淆9=L({1＄2;2＄3}＄{3＄;4＄5}):泭背49澐

泭背п閻ロ硾AA緖麯吹Ъ硾閻ロ毗/

(number＄disor)尻閻

Number愛グ硾閻＄Divisor愛硾閻(divisorЩ幔愛蕝奬掛

苓∠A1=51＄細梧淆9=(A1＄4):泭背3;=MOD(-101＄-2)泭背

尻閻

Number驤岌?嘎午A閻客＄Significance驤?尹尻閻Number洯が嘎午泂ょA娩閻B竚:苓∠尻閻number硾遠娩閻SignificanceA開閻絡(luò)引聆4引娩閻SignificanceAМ署＄細砂閻MROUND菅洼《蕝A靜菅嘎奬掛

苓∠A1=6.6876＄細梧淆9=R(A1＄4):A嶤ょ禺∠驤49澐

泭背尻閻塑AЪ錘尻閻痗按按なA魲客＄掛苓LIOIAL(2＄3＄4)A泂ょ愛!/!!!┛毗/

LIOIAL(number1nuber2...)尻閻

Number1＄number2＄...驤49引洯が砂閻Multinomial泂ょA129х閻客尻閻B竚:檔砂閻盡│爾榺9再?朮佼櫃:靜靭角奬掛

MULTINOMIAL(2＄3＄4)泭背A禺∠愛

尻閻

Number驤炸嶤ょAМх閻客B竚:尻閻number犲普驤Мх閻客尻閻＄Щ拖壟A緖麯吹苓皆＄交禺∠批蕾洼《0A靜菅嘎午┛苓∠number皓勵驤溜閻＄細観奬掛

苓∠A1=31.5＄細梧淆9=(A1):泭背33;=ODD(3)泭背3;=ODD(-26.38)泭背49澐

泭背箱泉ぬ征＄?咋峅閻88據(jù)14拐┛尻閻

Щ蝝奬掛

梧淆9=PI():泭背49澐

泭背縵奘閻垓A按椡毗

W尻閻

交шNumber愛檸閻＄Power愛薜閻＄批靭遠愛黃竚奬閻B竚:靭遠499:泂ょヰ苑龕POWER砂閻臾が按椡泂ょ＄掛苓梧淆9=52:Ъ9=PWE(5＄2):4翁┛奬掛

苓∠A1=25.37＄細梧淆9=PWE(A1＄7):泭背 ;=POWER(4＄5/4)泭背5.656854┛

尻閻

Number1＄number2＄...愛1咋30х蝝?ロ按A閻垓尻閻奬掛

苓∠鋤舷?A1=24┚A2=36┚A3=80＄細梧淆9=PRODUC(A1:A3)泭背69120;=PRODUCT(12＄26＄39)泭背

尻閻

Numerator愛グ硾閻＄Denominator愛硾閻┛奬掛

苓∠A1=86┚A2=9＄細梧淆9=IE(A1＄A2):泭背9;=QUOTIENT(-10＄3)泭背

尻閻

Angle愛蝝?棤雖耜湍欸Aこ?欸奬掛

苓∠A1=90＄細梧淆9=AIAS(A1):泭背1.57＄=RADIANS(360)泭背6.28(批神п拐峅閻49澐

泭背Мх絡(luò)引40峅引1A籂┳閻＄馞澈嶤ょ朮凱と(F9堦)岌泭背Мх霰A閻客┛

尻閻

Щ蝝B竚:苓∠?40耜a＄b扱浡A籂┳奬閻＄靭遠角49梧淆9=RAND()*(b-a苓∠板昻М鋤舷?坑櫂49梧淆9=A():＄ケ據(jù)板暗樿十璋Ч蕾魁F9堦＄岌科欝40Мх紳充A籂┳閻┛奬掛

梧淆9=A()100:泭背Мх絡(luò)引4引0┚峅引1000A籂┳閻49澐

欝40拐引пх薜奘閻客扱浡AМх籂┳閻＄馞澈脬霰嶤ょ朮凱と(蕾F9堦)碝岌泭背霰A閻客┛

W尻閻

Bottom驤RANDBETWEEN砂閻靭幔泭背A龜峅籂┳閻＄Top驤RANDBETWEEN砂閻靭幔泭背A龜絡(luò)籂┳閻┛奬掛

梧淆 ):岌泭背Мх絡(luò)引4引1000┚峅引4引9999A籂┳閻

尻閻

Number愛蝝?棤雖A癅萸貨閻垓┛form細驤Мх閻垓＄壟薜奘?棤雖A機47閻垓逼淆┛靭遠閲甌侯咋ば充＄籂46客A迷爾叀引ば鋤奬掛

梧淆9=A(499＄0):泭背9I:;=OA(499＄1)泭背

尻閻

Number驤蝝?杯嘎陰午A閻垓;Num_digits愛薜奘A拐閻＄Number蕾繒拐閻洯が擁B竚:苓∠num_digits絡(luò)引0＄細杯嘎陰午咋薜奘A峅閻拐;苓∠num_digits4引0＄細杯嘎陰午咋龜褓?A濶閻;苓∠峅引0＄細板峅閻88朿鎌蕾薜奘拐閻杯嘎陰午奬掛

苓∠A1=65.25＄細梧淆9=(A1＄1):泭背65.3;=ROUND(82.149＄2)泭背82.15;=ROUND(21.5＄-1)泭背49澐

蕾聟尹客麹峅AМ閻垓┛毗/

W(nmber＄umdiits)尻閻

Number驤蝝?菅Ч嘎午A黃竚奬閻＄Num_digits薜奘嶤ょA峅閻拐閻B竚:ROUNDDOWN砂閻塑ROUND砂閻A49澐ロ賀＄Щ趨扱擁驤ROUNDDOWN砂閻疽驤菅Ч嘎午閻垓9=ROUNDDOWN(A10)3)泭背3.141;=ROUNDDOWN(-3.14159＄1)泭背-3.1;=ROUNDDOWN(31415.92654＄-2)泭背31400┛尻閻

Number愛蝝?嘎午A黃竚奬閻＄Num_digits薜奘嘎午A閻垓拐閻∠∠??Aロ櫂拐閻苓∠A1=65.251＄細梧淆90):泭背66;=ROUNDUP(A11)泭背66;=ROUNDUP(A12)泭背65.26;=ROUNDUP(-3.14159＄1)泭背-3.2;=ROUNDUP(31415.92654＄-2)31500┛49澐

泭背椡囁閻A塑毗

(n尻閻

X椡囁閻A橺午客＄N愛xA?旡按椡＄M愛囁閻ш馞М旡A按椡nA罇懜迷爾客＄Coefficients愛Мa(chǎn)祭Ъx錘囁按椡B竚:SERIESSUM砂閻盡│爾榺9再?朮佼櫃:遠據(jù)靜幔角奬掛

苓∠鋤舷?A1=65.25＄細梧淆9=SEIESS(A1＄3＄2＄6):泭 49澐

泭背閻垓Aヰ吹┛緖閻泭背1＄蕝泭背0＄麯閻餒泭背-1┛

尻閻

Number驤蝝?泭背ヰ吹A(chǔ)黃竚奬閻奬掛

苓∠A1=65.25＄細梧淆9=SI(A1):泭背1;=SIGN(6-12)泭背-1;=SIGN(9-9)泭背

尻閻

Number驤炸|緖湶客AМхこ?欸(?49湍欸鋤拐)＄苓∠壟A鋤拐驤欸＄細犲普按遠PI()/180棤雖愛湍欸┛奬掛

苓∠A1=60＄細梧淆9=SI(A1PI()/180):泭背0.866＄昌60欸こ?A緖湶客┛

尻閻

Number愛黃竚奬閻奬掛

梧淆9=SI(0:泭背11013.23287＄=SINH(-6)泭背-

尻閻

Number愛蝝?樅靜謬AМх緖閻奬掛

苓A1=81＄細梧淆9=S(A1):泭背9;=SQRT(4+12)泭背尻閻

Number驤49?Ъ征ロ按A緖奬閻B竚:SQRTPI砂閻盡│爾榺9再?朮佼櫃:遠據(jù)靜幔角49┛苓∠尻閻number<0＄細砂閻SQRTPI泭背園氅客#NUM!┛奬掛

梧淆9=SPI(1):泭背1.772454＄=SQRTPI(2)泭背2.506628┛暗樿SUBTOTAL砂閻尹交洯が癌鎬┛毗

尻閻

Function_num111扱浡A勈ケ閻＄49?薜奘再+?疽?guī)Cょ角49A砂閻(1驤AVERAGE;2COUNT;3MAX;5MIN;6PRODUCT;7STDEV;8STDEVP;9SUM;10VAR;11VRP)Ref1ref2;細驤蝝?再+?疽129х準平聆淅奬掛

苓∠A1=1┚A2=2┚A3=3＄細梧淆9=SBTAL(9＄A1:A3):岌角49SUM砂閻尹9A1:A3:準平?jīng)??疽＄交∠愛49澐

泭背昻Мш毗/

S(number1nmber2...)┛尻閻

Number1＄number2＄...愛1咋30х蝝?|塑A閻客(繍蓴焯樿客心陷┥と毚淆)┚準平聆淅奬掛

苓∠A1=1┚A2=2┚A3=3＄細梧淆9=S(A1:A3):泭背6;=SUM("3"＄2＄TRUE)泭背6＄輩愛"3"グ棤雖耜閻垓3＄澘焯樿客TRUEグ棤雖耜閻垓1┛

nge愛49Ariteria584氈耜ASum_rage愛蝝|塑A鋤舷?┚準平聆淅49┛ш9ш囁AAFB祭┛細梧淆愛9=SUIF(B1:B100＄"ш囁"＄F1:F1000):＄交ш9B1:B1000:愛觸轄焯樿坂霙鰹蟾A鋤舷?準平＄"ш囁"愛坂霙?王＄嶬驤詠詠聰嶤B1:B100ш添に愛9ш囁:A鋤舷?＄F1:F100愛奬盫|塑A49澐

板縵奘Aш＄岌閻氈浡尹櫂A舷?毗/

SPU(arra1＄arra2＄arra3＄...)尻閻

Array1＄array2＄array3＄...愛2厫30х閻氈＄交ロ櫂舷?蝝?洯がロ按槭|塑┛奬掛

梧淆9=SPO({3＄4;8＄6;1＄9}＄{27;6＄7;53}):A嶤ょ禺∠驤156┛49澐

泭背腑│尻閻A樅靜塑毗

尻閻

Number1＄number2＄...愛1咋30х蝝?|樅靜塑A尻閻＄壟靭遠驤閻客┚準平┚淅49聆閻氈┛奬掛

苓∠A1=1┚A2=2┚A3=3＄細梧淆9=SUMSQ(A1:A3)泭背14(昌12+22+32=14)┛

2尻閻

Array_x愛?Мх閻氈聆閻客準平┛Array_y愛?因х閻氈聆閻客準平奬掛

苓∠A1=1┚A2=2┚A3=3┚B1=4┚B2=5┚B3=6＄細梧淆9=SU22(A1:A3＄B1:B3):泭背-49澐

泭背п閻氈шA樅靜塑A疽塑＄繒+泂ょ板聰嶤ш甌棗??毗/

S2P2(arra_＄arra_)尻閻

Array_x愛?Мх閻氈聆閻客準平＄Array_y愛?因х閻氈聆閻客準平奬掛

苓∠A1=1┚A2=2┚A3=3┚B1=4┚B2=5┚B3=6＄細梧淆9=SU2P2(A1:A3＄B1:B3):泭背

_尻閻

Array_x愛?Мх閻氈聆閻客準平┛Array_y愛?因х閻氈聆閻客準平奬掛

苓∠A1=1┚A2=2┚A3=3┚B1=4┚B2=5┚B3=6＄細梧淆9=SUX2(A1:A3＄B1:B3):泭背

尻閻

Number愛蝝?|緖最Aこ?欸＄遠湍欸と?┛苓∠尻閻A鋤拐驤欸＄靭遠按遠P1()/180棤雖愛湍欸┛奬掛

苓∠A1=60＄細梧淆9=A(A1PI()/180):泭背1. ;TAN(1)泭背1.

尻閻

Number愛黃竚奬閻奬掛

苓∠A1=60＄細梧淆9=A(A1):泭背1＄=TANH(0.5)泭背

尻閻

Number驤蝝?肭織峅閻瞟再A閻垓＄Num_digits細薜奘観98峅閻An欸(込拐峅閻B竚:TRUNC砂閻靭遠蕾蝝?肭神閻垓A峅閻瞟再＄澘INT砂閻細岌閻垓菅Ч嘎午咋龜褓?A濶閻┛INT塑TRUNC砂閻板擁32麯閻餒│腑Щ趨:TRUNC(-4.3)泭背-4＄澘INT(-4.3)泭背-5┛奬掛

苓∠A1=78.652＄細梧淆9=TRUNC(A11)泭背78.6＄=TRUNC(A1＄2)泭背78.65＄=TRUNC(-8.963＄2)泭背49澐

泭背М氈閻蟾ЪA聟尹球杙A樅批客＄檔砂閻靭遠昫\閻蟾(掛苓堙40A昻ぎ稅栝耜蠶)A毗/

AVEEV(nmbe＄numer2