您现在的位置是:首页 > 办公软件 > excleexcle
EXCEL 突破30个参数的限制
爱读书aread.cc2022-10-03 23:30:11excle0人已围观
简介.爱读书aread.cc翻译,转载请保留此信息 . 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 argument
.爱读书aread.cc翻译,转载请保留此信息 .
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.
Tags:
很赞哦! ()
下一篇:EXCEL 避免输入空格
相关文章
随机图文
-
excel文本替换_excel匹配替换
Excel-查找与替换 在Excel中,常用功能【查找】和【替换】给我们的工作带来了很多方便,但 -
EXCEL 寻找指定区域最大值的地址
爱读书aread.cc翻译,转载请保留此信息 .如图,寻找A1:A10中最大数值的地址。我把这个公式介绍给大家,是因为其中包括了MAX,INDEX,MATCH,CELL等公式的使用。这几个公式在实际工作中都很常用,特别是中间的两个公式。建议 -
EXCEL 插入水印
爱读书aread.cc翻译,转载请保留此信息 . To insert the text "Confidential" behind the data in a Financial Statements report: 1. Select one of the toolbars, right-click, and select the WordArt toolbar fro -
excel新建空白工作簿_excel新建文档
Excel-新建工作簿
留言与评论 (共有 条评论) |