excel函數(shù)應(yīng)用教程

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

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

尻閻

Loicl1loicl＄;愛(ài)炸ぅ'19A1Ｅ30х焯樿と毚淆＄壟凹A禺拖聆愛(ài)TRUE(13)聆愛(ài)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嶤ょ禺∠愛(ài)TRUE聆FALSEA黃皆閻客聆と毚淆;value_if_true驤Logical_test愛(ài)TRUE餒砂閻A泭背客苓logical_test愛(ài)TRUE槭а水j芋value_if_true＄細(xì)泭背TRUE┛澘аvalue_if_true靭遠(yuǎn)驤Мхと毚淆;value_if_false驤Logical_test愛(ài)FALSE餒砂閻A泭背客┛苓∠logical_test愛(ài)FALSE槭а水jvalue_if_false＄細(xì)泭背FALSE┛value_if_false伊靭遠(yuǎn)驤Мхと毚奬掛

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

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

尻閻

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

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

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

尻閻

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

苓∠A1=6┚A2=8＄細(xì)梧淆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準(zhǔn)平A朿Цこ?鋤舷?A?淆┚拐響聆坑婪4鑑皖＄檔砂閻挨?49引観薨Ъ交壟62壞と?ゆ檣A公婪畧毗

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

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

泭背尹櫂引昻М園氅+鰭A閻?ài)颉畿摺熄ⅸ@氅細(xì)泭背#N/A┛板IF砂閻ш靭遠(yuǎn)角49ERROR.TYPEぅ\園氅客＄槭泭

P尻閻

Error_val愛(ài)蝝?煬咋交閻?ài)蛟伐锳Мх園氅+鰭┛巫ゑerror_val靭遠(yuǎn)驤奬盫A園氅客＄廻壟?棗愛(ài)Мх鋤舷?淅49＄澘泭背泭背泭背泭背泭背6＄#N/A泭背7＄交延園氅細(xì)泭背奬掛

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

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

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

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

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

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

\栝尻閻A溜峽畧＄苓∠尻閻愛(ài)峽閻泭背TRUE＄晴細(xì)泭背毗

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

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

\栝尻閻A溜峽畧＄苓∠尻閻愛(ài)溜閻泭背TRUE＄晴細(xì)泭背毗

尻閻

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

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

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

尻閻

value愛(ài)?棤充A客┛砂閻N靭遠(yuǎn)棤充Чと祭査A客:閻?ài)驔姳硻n閻?ài)颉珙潻紱姳硻n顫┘A檣祭吹＄TRUE泭背泭背0＄園氅客(苓#DIV/0!)泭背檔園氅客＄交延客泭背奬掛

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

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

ぁt鋤舷奬掛

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

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

尻閻

value靭遠(yuǎn)驤ExcelшA閻蟾＄苓閻?ài)颟鞠荸嫂眷虡杩蛙遶alue愛(ài)閻?ài)驔姳?＄驤陷┥泭背2＄焯樿客泭背4＄園氅客泭背16＄閻氈泭背64┛奬掛

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

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

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

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

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

AIT(issu＄matuit＄rate＄尻閻

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

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

尻閻

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

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

榱件O月P號(hào)A同B49澐

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

尻閻

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

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

尻閻

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

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

尻閻

Settlement驤斝錯(cuò)A耜渦顫＄Maturity愛(ài)│翁斝錯(cuò)A咋┘顫＄Frequency愛(ài)榱掩皖澈閻(苓∠蕾榱錣掩＄frequency=1;蕾署榱┘錣掩＄frequency=2;蕾埖錣掩＄frequency=4)＄Basis愛(ài)顫嶤閻娩剛+鰭(0聆水j愛(ài)30/360＄1愛(ài)奬盫酪閻/奬盫酪閻＄2愛(ài)奬盫酪閻/360＄3愛(ài)奬盫酪閻/365＄4愛(ài)炅￠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愛(ài)咲ぬ＄Nper愛(ài)疽掩琪┘閻＄Pv愛(ài)タ客＄Start_period愛(ài)嶤ょшA?┘(掩琪┘閻閲1浤丐嶤閻)＄End_period愛(ài)嶤ょшA┤┘＄Type愛(ài)掩琪餒浡+鰭(0(蕝)愛(ài)┘┤掩琪＄1愛(ài)┘際掩琪)┛令令.件月MPRIN49澐

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

尻閻

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

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

尻閻

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

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

尻閻

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

泭背│翁斝錯(cuò)A仱タぬ毗

尻閻

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

岌蕾再閻と?A翁?棤雖愛(ài)蕾峅閻と?A翁?＄苓斝錯(cuò)翁?＄棤雖愛(ài)峅閻と?A閻?ài)蚺?/p>

尻閻

Fractional_dollar遠(yuǎn)再閻と?A閻?ài)颉鏔raction再閻шA再餧(濶閻令6.號(hào)49澐

岌蕾峅閻と?A翁?棤雖愛(ài)蕾再閻と?A翁?毗

尻閻

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

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

尻閻

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

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

尻閻

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

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

尻閻

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

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

尻閻

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

泭背М澈畧掩皖斝錯(cuò)A咲ぬ毗

尻閻

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

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

尻閻

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

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

尻閻

values愛(ài)閻氈聆鋤舷?A淅49＄繍牲49?嶤ょ泭背A坑瞟鍮ゐぬA閻?ài)颟縂uess愛(ài)尹砂閻IRR嶤ょ禺∠A迦嶤客工I分PM49澐

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

尻閻

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

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

A尻閻

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

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

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

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

尻閻

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

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

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

?汍角49仱タぬ遠(yuǎn)心Мa(chǎn)祭┣?錣査(麯客)塑鍮午(緖客)＄泭背М?dāng)鷤[A閤タ客毗

愛(ài)咋左代.O號(hào)號(hào)FPRI49澐

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

尻閻

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

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

尻閻

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

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

尻閻

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

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

尻閻

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

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

尻閻

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

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

尻閻

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

泭背奘┘掩皖A(yù)蹩客$100A│翁斝錯(cuò)A翁?毗

尻閻

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

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

尻閻

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

泭背咋┘掩皖A(yù)蹩客$100A│翁斝錯(cuò)A翁?毗

尻閻

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

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

尻閻

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

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

尻閻

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

泭背М澈畧掩皖A(yù)│翁斝錯(cuò)咋┘鍮背A腩璽毗

尻閻

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

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

尻閻

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

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

尻閻

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

泭背迫櫃錯(cuò)A4鐔鍮ゐぬ毗

尻閻

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

泭背蹩客$100A迫櫃錯(cuò)A翁?毗

尻閻

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

泭背迫櫃錯(cuò)A鍮ゐぬ毗

尻閻

Settlement愛(ài)迫櫃錯(cuò)A耜渦顫＄Maturity愛(ài)迫櫃錯(cuò)A咋┘顫＄Pr愛(ài)蹩客$100A迫櫃錯(cuò)A翁?有號(hào)49澐

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

尻閻

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

嶤ょ禺∠A迦嶤客下NP49澐

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

5代.同I司L49澐

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

尻閻

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

泭背茉翁浸がA│翁斝錯(cuò)A榱鍮ゐぬ毗

尻閻

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

泭背咋┘掩皖A(yù)│翁斝錯(cuò)A榱鍮ゐぬ毗

A尻閻

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

尻閻

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

泭背Bessel砂閻客

左.B司分分司49澐

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

B司分分司L49澐

泭背Bessel砂閻客＄伊に愛(ài)Weber砂閻聆ann砂閻

I工號(hào)司49澐

岌因洯策閻棤雖愛(ài)順洯策閻毗

尻閻

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

岌因洯策閻棤雖愛(ài)順檎洯策閻毗

＄尻閻

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

岌因洯策閻棤雖愛(ài)悟洯策閻毗

m＄尻閻

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

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

E尻閻

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

岌閻?ài)蜷嚙鐨G脽a聰棤雖咋塵Мх欸脽a聰毗

尻閻

Number驤遠(yuǎn)from_units愛(ài)鋤拐A蝝?洯が棤雖A閻客┛From_unit驤閻客numberA鋤拐┛To_unit驤禺∠A鋤拐令代.號(hào)司件工49澐

岌順洯策閻棤雖愛(ài)因洯策閻毗

m＄尻閻

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

岌順洯策閻棤雖愛(ài)順檎洯策閻毗

m＄尻閻

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

岌順洯策閻棤雖愛(ài)悟洯策閻毗

m＄尻閻

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

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

尻閻

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

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

jERF令5.司RF49澐

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

尻閻

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

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

尻閻

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

岌順檎洯策閻棤雖愛(ài)因洯策閻毗

＄尻閻

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

岌順檎洯策閻棤雖愛(ài)順洯策閻毗

尻閻

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

岌順檎洯策閻棤雖愛(ài)悟洯策閻毗

m＄尻閻

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

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

尻閻

Inumber?愛(ài)蝝?嶤ょ交聟尹客A羊閻49澐

泭背遠(yuǎn)x+yi聆x+yj陷┥?淆と?A羊閻A?a閻┛尻閻

Inumber?愛(ài)蝝?嶤ょ交?a閻A羊閻尻閻

Inumber愛(ài)49?嶤ょこ?欸客A羊閻49澐

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

Inumber愛(ài)蝝?嶤ょ交誤棥閻A羊閻49澐

泭背遠(yuǎn)x+yi聆x+yj陷┥?淆と?A羊閻A開(kāi)湶┛尻閻

Inumber愛(ài)蝝?嶤ょ交開(kāi)湶客A羊閻49澐

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

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

泭背遠(yuǎn)x+yi聆x+yj陷┥?淆と?A羊閻A薜閻┛尻閻

Inumber?愛(ài)蝝?嶤ょ交薜閻A羊閻49澐

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

尻閻

Inumber愛(ài)蝝?嶤ょ交勈ケ尹閻A羊閻49澐

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

Inumber?愛(ài)蝝?嶤ょ交棗49尹閻A羊閻49澐

泭背遠(yuǎn)x+yi聆x+yj陷┥?淆と?A羊閻A遠(yuǎn)2愛(ài)檸閻A尹閻┛尻閻

Inumber愛(ài)蝝2愛(ài)檸閻A尹閻客A49澐

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

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

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

nuber1inmbr2＄;愛(ài)129х49?ロ按A羊閻49澐

泭背遠(yuǎn)x+yix+yj陷┥?淆と?A羊閻A奬a閻┛尻閻

Inumber?愛(ài)蝝?嶤ょ交奬a閻A羊閻49澐

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

Inumber?愛(ài)蝝?嶤ょ交緖湶A羊閻49澐

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

Inumber愛(ài)蝝?嶤ょ交樅靜謬A羊閻49澐

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

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

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

U尻閻

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

Number驤炸棤雖A悟洯策閻

尻閻

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

Number驤炸棤雖A悟洯策閻

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

遠(yuǎn)陷垓澤淆泭背尹朮凱ěш昻М鋤舷?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愛(ài)М陷┥＄薜馭凱愛(ài)養(yǎng)瞟淅49A朮凱とA雛に＄苓∠水jshet_tet＄細(xì)Щ角49黃皆朮凱とA雛に┛奬掛

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

尻閻

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

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

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

尻閻

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

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

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

)尻閻

Array愛(ài)蝝?煬咋交祭閻A閻氈┚閻氈梧淆聆尹鋤舷?準(zhǔn)平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閻客＄壟靭遠(yuǎn)驤閻客┚淅49聆陷垓э;Table_array驤蝝?板交ш薯艫閻蟾閻蟾靭遠(yuǎn)角49尹準(zhǔn)平聆準(zhǔn)平雛にA淅49＄Table_arrayA?МがA閻客靭遠(yuǎn)驤陷┥┚閻?ài)蝰鲮虡杩桐縍ow_index_numш炸泭背A淳篊客Aが檣吹┛Range_lookup愛(ài)М焯樿客＄薜馭砂閻HLOOKUP薯艫餒驤n?淳篊＄洦驤?賀淳篊49澐

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

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

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

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

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

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

苓∠A1=68┚A2=96┚A3=90＄細(xì)梧淆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グ??愛(ài)R1C1-逼淆A淅49┛平(菅脽)ш薯艫閻客＄ケ據(jù)泭背?因х鋤が準(zhǔn)平聆鋤祭準(zhǔn)平шロ趨拐響A閻客;交閻氈澤淆板閻氈A?Мが聆?М祭薯艫薜奘A閻客ケ據(jù)泭背閻氈A龜據(jù)Мが聆龜據(jù)М祭шロ趨拐響A閻客毗/1(菅脽澤淆毗/2(閻氈澤淆尻閻1(菅脽澤淆):Lookup_value愛(ài)砂閻LOOKUP板?Мх菅脽ш腑?薯艫A閻客┛Lookup_value靭遠(yuǎn)愛(ài)閻?ài)颟鞠荸嫂眷虡杩婉鲥觊?(閻氈澤淆):Lookup_value愛(ài)砂閻LOOKUP板閻氈ш腑?薯艫A閻客┛Lookup_value靭遠(yuǎn)愛(ài)閻?ài)颟鞠荸嫂眷虡杩婉隹惿惪虯雛に聆淅49┛苓∠砂閻LOOKUP艫Щ咋lookup_value＄細(xì)角49閻氈ш峅引聆4引lookup_valueA龜絡(luò)閻客┛Array愛(ài)繍牲陷┥┚B竚:Lookup_vectorA閻客犲普蕾渚檣袤祭＄晴細(xì)LOOKUP砂閻Щ幔泭背緖?A禺∠＄尻閻шA陷┥Щ準(zhǔn)再絡(luò)峅昂9=LOOKUP(76A1:A4)3})泭背2┛角49MATCH砂閻┛毗

C尻閻

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

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

尻閻

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

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

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

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

Array驤蝝?煬咋交が閻A閻氈┚閻氈梧淆聆尹鋤舷?準(zhǔn)平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雛に┛苓∠á│┆璽得＄ゆ檣驤板┥般嶤ょ┳Ц泂が＄畬梓檔尻閻愛(ài)ぁt┛topc1＄tpi2＄...愛(ài)1咋28х尻閻＄洧49澐

泭背準(zhǔn)平A棤響(A?Мが凱愛(ài)霰閻氈A?М祭＄閻氈A?因が凱愛(ài)霰閻氈A?因祭＄遠(yuǎn)繒+褥)┛毗/

ASPSE(arra)┛尻閻

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

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

尻閻

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

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

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

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

泭背遠(yuǎn)湍欸と?A尻閻A新開(kāi)湶客＄椑博驤0~征┛尻閻

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

苓∠A1=0.5＄細(xì)梧淆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愛(ài)昻Мこ?欸A緖湶客＄交絡(luò)峅悅引-1Ｅ1扱浡奬掛

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

number愛(ài)黃竚奬閻奬掛

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

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

AA(numer)尻閻

number愛(ài)昻Мこ?欸A緖最客┛苓∠?49欸と?泭背A新緖最客＄蝝岌禺∠按遠(yuǎn)奬掛

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

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

尻閻

X_num愛(ài)縵奘88AX緋辿＄Y_num愛(ài)縵奘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愛(ài)炸泭背A閻客＄Significance愛(ài)炸泭背A龜峅毅閻B竚:頷拖numberA緖麯苓皆碝驤蕾洼《088A靜菅泭背禺∠┛苓∠number驤SignificanceA毅閻細(xì)泭背A閻客驤交勈怤┛奬掛

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

尻閻

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

弓擄│10雛鮎或29猋絶＄閲ш漊査黃竚п曳貅篊尻?duì)栒衲嚒缂?xì)嶤ょ梧淆愛(ài)9=COBIN(102)靭遠(yuǎn)煬査45?貅篊靜籾

尻閻

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

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

number愛(ài)黃竚奬閻奬掛

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

range愛(ài)蝝?聰嶤Aヰ崇?王A鋤舷?閻ムA準(zhǔn)平;Criteria愛(ài)尻Ъ嶤ょA鋤舷??王交澤淆靭遠(yuǎn)愛(ài)閻?ài)蝰鱿荸?36┚">160"塑"64"4)┛交ш閻?ài)蜢z遠(yuǎn)ラ褓昂午＄と毚淆塑陷┥犲普爾淅吹奬掛

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

尻閻

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

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

尻閻

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

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

泭背eAn澈椡毗

尻閻

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

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

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

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

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

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

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

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

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

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

尻閻

Number1＄number2＄...129х閻客＄苓∠閻客愛(ài)蹍濶閻＄細(xì)肭已神濶┛奬掛

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

尻閻

Number愛(ài)蝝?擁32A黃竚Мх奬閻奬掛

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

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

尻閻

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

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

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

尻閻

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

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

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

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

泭背遠(yuǎn)10愛(ài)檸A尹閻┛尻閻

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

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

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

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

Array驤佼│ロ4が祭閻A閻客閻氈＄壟靭遠(yuǎn)驤鋤舷?準(zhǔn)平＄掛苓A1:C3;伊靭遠(yuǎn)驤棗閻閻氈苓聆隻驤п隻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愛(ài)グ硾閻＄Divisor愛(ài)硾閻(divisorЩ幔愛(ài)蕝奬掛

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

尻閻

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

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

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

LIOIAL(number1nuber2...)尻閻

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

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

尻閻

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

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

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

Щ蝝奬掛

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

泭背縵奘閻?ài)駻按椡毗

W尻閻

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

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

尻閻

Number1＄number2＄...愛(ài)1咋30х蝝?ロ按A閻?ài)蝈觊悐\掛

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

尻閻

Numerator愛(ài)グ硾閻＄Denominator愛(ài)硾閻┛奬掛

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

尻閻

Angle愛(ài)蝝?棤雖耜湍欸Aこ?欸奬掛

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

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

尻閻

Щ蝝B竚:苓∠?40耜a＄b扱浡A籂┳奬閻＄靭遠(yuǎn)角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愛(ài)蝝?棤雖A癅萸貨閻?ài)颟縡orm細(xì)驤Мх閻?ài)颉鐗呸缔?棤雖A機(jī)47閻?ài)虮葡快z遠(yuǎn)閲甌侯咋ば充＄籂46客A迷爾叀引ば鋤奬掛

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

尻閻

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

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

蕾聟尹客麹峅AМ閻?ài)颟颗?

W(nmber＄umdiits)尻閻

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

Number愛(ài)蝝?嘎午A黃竚奬閻＄Num_digits薜奘嘎午A閻?ài)蚬臻悺稀??Aロ櫂拐閻苓∠A1=65.251＄細(xì)梧淆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愛(ài)xA?旡按椡＄M愛(ài)囁閻ш馞М?dāng)鶤按椡nA罇懜迷爾客＄Coefficients愛(ài)Мa(chǎn)祭Ъx錘囁按椡B竚:SERIESSUM砂閻盡│爾榺9再?朮佼櫃:遠(yuǎn)據(jù)靜幔角奬掛

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

泭背閻?ài)駻ヰ吹┛緖閻泭背1＄蕝泭背0＄麯閻餒泭背-1┛

尻閻

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

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

尻閻

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

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

尻閻

Number愛(ài)黃竚奬閻奬掛

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

尻閻

Number愛(ài)蝝?樅靜謬AМх緖閻奬掛

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

Number驤49?Ъ征ロ按A緖奬閻B竚:SQRTPI砂閻盡│爾榺9再?朮佼櫃:遠(yuǎn)據(jù)靜幔角49┛苓∠尻閻number<0＄細(xì)砂閻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;細(xì)驤蝝?再+?疽129х準(zhǔn)平聆淅奬掛

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

泭背昻Мш毗/

S(number1nmber2...)┛尻閻

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

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

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

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

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

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

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

泭背腑│尻閻A樅靜塑毗

尻閻

Number1＄number2＄...愛(ài)1咋30х蝝?|樅靜塑A尻閻＄壟靭遠(yuǎn)驤閻客┚準(zhǔn)平┚淅49聆閻氈┛奬掛

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

2尻閻

Array_x愛(ài)?Мх閻氈聆閻客準(zhǔn)平┛Array_y愛(ài)?因х閻氈聆閻客準(zhǔn)平奬掛

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

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

S2P2(arra_＄arra_)尻閻

Array_x愛(ài)?Мх閻氈聆閻客準(zhǔn)平＄Array_y愛(ài)?因х閻氈聆閻客準(zhǔn)平奬掛

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

_尻閻

Array_x愛(ài)?Мх閻氈聆閻客準(zhǔn)平┛Array_y愛(ài)?因х閻氈聆閻客準(zhǔn)平奬掛

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

尻閻

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

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

尻閻

Number愛(ài)黃竚奬閻奬掛

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

尻閻

Number驤蝝?肭織峅閻瞟再A閻?ài)颉鏝um_digits細(xì)薜奘観98峅閻An欸(込拐峅閻B竚:TRUNC砂閻靭遠(yuǎn)蕾蝝?肭神閻?ài)駻峅閻瞟再＄澘INT砂閻細(xì)岌閻?ài)蜉学垢挛缯旕?A濶閻┛INT塑TRUNC砂閻板擁32麯閻餒│腑Щ趨:TRUNC(-4.3)泭背-4＄澘INT(-4.3)泭背-5┛奬掛

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

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

AVEEV(nmbe＄numer2