round 函数ROUND(MAX(((I4-SUM(K4:O4))-2000)*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615},0),2)有人可以帮我解释下,

来源:学生作业帮助网 编辑:六六作业网 时间:2024/11/16 15:25:52
round函数ROUND(MAX(((I4-SUM(K4:O4))-2000)*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615},0)

round 函数ROUND(MAX(((I4-SUM(K4:O4))-2000)*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615},0),2)有人可以帮我解释下,
round 函数
ROUND(MAX(((I4-SUM(K4:O4))-2000)*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615},0),2)
有人可以帮我解释下,

round 函数ROUND(MAX(((I4-SUM(K4:O4))-2000)*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615},0),2)有人可以帮我解释下,
SUM(K4:O4)当然表示求和啦,(I4-SUM(K4:O4))-2000)得到一个数,{1,2,3,4,5,6,7,8,9}表示一个数列,{0,1,5,15,55,135,255,415,615}同样也表示一个数列.则((I4-SUM(K4:O4))-2000)*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615}得到的也是一个数列,我们不妨设为A数列.则MAX(A,0)表示A数列中所有数字和0当中的最大值,设为B.ROUND(B,2)表示对B取小数点后2位整.