EXCEL 突破30個(gè)參數(shù)的限制

2018-09-23 13:56 更新
.中國(guó)教程網(wǎng)zhangditony翻譯,轉(zhuǎn)載請(qǐng)保留此信息 .
 

Exceeding the 30-argument limit
Excel has a 30-argument limit for statistical functions. It's easy to get around, though, if you group some
of your arguments within parentheses().  
For example,Instead of entering SUM(A1,A2,A3…,A33), you can enter SUM((A1,A2,A3),A4…,A33), and Excel will
accept the grouped arguments as a single argument within the formula
.

20070713_c51a6a2f44ef590de6f3u0pejvnbxytb[1].gif

以上內(nèi)容是否對(duì)您有幫助:
在線筆記
App下載
App下載

掃描二維碼

下載編程獅App

公眾號(hào)
微信公眾號(hào)

編程獅公眾號(hào)