codecamp

EXCEL 突破30个参数的限制

.中国教程网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.

20070713_c51a6a2f44ef590de6f3u0pejvnbxytb[1].gif

EXCEL 制作工资条的一个简单方法
EXCEL 避免输入空格
温馨提示
下载编程狮App，免费阅读超1000+编程语言教程
取消
确定
目录

EXCEL 基础应用

EXCEL 函数应用

关闭

 MIP.setData({ 'pageTheme' : getCookie('pageTheme') || {'day':true, 'night':false}, 'pageFontSize' : getCookie('pageFontSize') || 20 }); MIP.watch('pageTheme', function(newValue){ setCookie('pageTheme', JSON.stringify(newValue)) }); MIP.watch('pageFontSize', function(newValue){ setCookie('pageFontSize', newValue) }); function setCookie(name, value){ var days = 1; var exp = new Date(); exp.setTime(exp.getTime() + days*24*60*60*1000); document.cookie = name + '=' + value + ';expires=' + exp.toUTCString(); } function getCookie(name){ var reg = new RegExp('(^| )' + name + '=([^;]*)(;|$)'); return document.cookie.match(reg) ? JSON.parse(document.cookie.match(reg)[2]) : null; }