当前位置:K88软件开发文章中心办公应用EXCEL → 文章内容

EXCEL 突破30个参数的限制

减小字体 增大字体 作者:佚名  来源:网上搜集  发布时间:2019-1-26 10:14:48

由 ?﹏???ζ???﹏﹏? 创建, 最后一次修改 2015-11-04 .中国教程网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 突破30个参数的限制