自定义函数 MCSUMSNTOEN 返回整数a至整数b的整数和

名称：MCSUMSNTOEN

备注：返回整数a至整数b的整数和。start_number是起始整数。end_number是终止整数。

引用位置：

=LAMBDA(start_number,end_number,LET(min,IF(start_number<=end_number,CEILING(start_number,1),CEILING(end_number,1)),max,IF(start_number<=end_number,INT(end_number),INT(start_number)),IF(min>max,"error!",IF(min=max,min,min+MCSUMSNTOEN(min+1,max)))))

插入函数对话框、函数参数对话框：

加载宏文件function Workbook_Open(){}中添加以下代码。

JSAREGISTER("user32.dll","CharPrevA","PPP","MCSUMSNTOEN","start_number,end_number",1,"用户定义",undefined,undefined,"返回整数a至整数b的整数和。",'"start_number是起始整数。","end_number是终止整数。"');