=PERMUT(5,5)
回車就可以了，返回的結果是120，函數有兩個參數，第壹個是總***有幾個數字，第二個是選幾個，中間用逗號隔開，妳可以輸入少點的數字來驗證壹下，如果=PERMUT(3,3)，返回的結果將會是6。
這個函數叫作排列函數，是考慮各種排列的順序的，還有壹個相類似的函數叫組合函數，不考慮順序的，combin(5,5),5個中選5個，不考慮順序，返回的結果必然是1，再用=combin(5,2)試壹下，就可以看出效果了。
三樓辦法可行，我用他的辦法取出了這120個數，妳看壹下，12345,12354,12435,12453,12534,12543,13245,13254,13425,13452,13524,13542,14235,14253,14325,14352,14523,14532,15234,15243,15324,15342,15423,15432,21345,21354,21435,21453,21534,21543,23145,23154,23415,23451,23514,23541,24135,24153,24315,24351,24513,24531,25134,25143,25314,25341,25413,25431,31245,31254,31425,31452,31524,31542,32145,32154,32415,32451,32514,32541,34125,34152,34215,34251,34512,34521,35124,35142,35214,35241,35412,35421,41235,41253,41325,41352,41523,41532,42135,42153,42315,42351,42513,42531,43125,43152,43215,43251,43512,43521,45123,45132,45213,45231,45312,45321,51234,51243,51324,51342,51423,51432,52134,52143,52314,52341,52413,52431,53124,53142,53214,53241,53412,53421,54123,54132,54213,54231,54312,54321