免费AI编程助手
EXCEL 突破30个参数的限制
2018-09-23 13:56 更新
.中国教程网zhangditony翻译，转载请保留此信息 .
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.
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](https://atts.w3cschool.cn/attachments/image/20151104/1446603972968202.gif "1446603972968202.gif")
以上内容是否对您有帮助：
更多建议：