求EXCEL公式解释什么意思=MAX((MIN(ABS($A$2:$A$21-$I2))=ABS($A$2:$A$21-$I2))*$A$2:$A$21)按照步骤能否理解为1、(MIN(ABS($A$2:$A$21-$I2))=ABS($A$2:$A$21-$I2)) MIN是取出数值里面最小值可后面这个=号不明白号啥意思2、
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/09 02:29:37
![求EXCEL公式解释什么意思=MAX((MIN(ABS($A$2:$A$21-$I2))=ABS($A$2:$A$21-$I2))*$A$2:$A$21)按照步骤能否理解为1、(MIN(ABS($A$2:$A$21-$I2))=ABS($A$2:$A$21-$I2)) MIN是取出数值里面最小值可后面这个=号不明白号啥意思2、](/uploads/image/z/11958159-39-9.jpg?t=%E6%B1%82EXCEL%E5%85%AC%E5%BC%8F%E8%A7%A3%E9%87%8A%E4%BB%80%E4%B9%88%E6%84%8F%E6%80%9D%3DMAX%28%28MIN%28ABS%28%24A%242%3A%24A%2421-%24I2%29%29%3DABS%28%24A%242%3A%24A%2421-%24I2%29%29%2A%24A%242%3A%24A%2421%29%E6%8C%89%E7%85%A7%E6%AD%A5%E9%AA%A4%E8%83%BD%E5%90%A6%E7%90%86%E8%A7%A3%E4%B8%BA1%E3%80%81%28MIN%28ABS%28%24A%242%3A%24A%2421-%24I2%29%29%3DABS%28%24A%242%3A%24A%2421-%24I2%29%29+MIN%E6%98%AF%E5%8F%96%E5%87%BA%E6%95%B0%E5%80%BC%E9%87%8C%E9%9D%A2%E6%9C%80%E5%B0%8F%E5%80%BC%E5%8F%AF%E5%90%8E%E9%9D%A2%E8%BF%99%E4%B8%AA%3D%E5%8F%B7%E4%B8%8D%E6%98%8E%E7%99%BD%E5%8F%B7%E5%95%A5%E6%84%8F%E6%80%9D2%E3%80%81)
求EXCEL公式解释什么意思=MAX((MIN(ABS($A$2:$A$21-$I2))=ABS($A$2:$A$21-$I2))*$A$2:$A$21)按照步骤能否理解为1、(MIN(ABS($A$2:$A$21-$I2))=ABS($A$2:$A$21-$I2)) MIN是取出数值里面最小值可后面这个=号不明白号啥意思2、
求EXCEL公式解释什么意思=MAX((MIN(ABS($A$2:$A$21-$I2))=ABS($A$2:$A$21-$I2))*$A$2:$A$21)
按照步骤能否理解为
1、(MIN(ABS($A$2:$A$21-$I2))=ABS($A$2:$A$21-$I2)) MIN是取出数值里面最小值可后面这个=号不明白号啥意思
2、(MIN(ABS($A$2:$A$21-$I2))=ABS($A$2:$A$21-$I2))*$A$2:$A$21这一步不就是等于了以后乘以$A$2:$A$21嘛
3、MAX((MIN(ABS($A$2:$A$21-$I2))=ABS($A$2:$A$21-$I2))*$A$2:$A$21)最后一步是取出最大值
求EXCEL公式解释什么意思=MAX((MIN(ABS($A$2:$A$21-$I2))=ABS($A$2:$A$21-$I2))*$A$2:$A$21)按照步骤能否理解为1、(MIN(ABS($A$2:$A$21-$I2))=ABS($A$2:$A$21-$I2)) MIN是取出数值里面最小值可后面这个=号不明白号啥意思2、
{=MAX((MIN(ABS($A$2:$A$21-$I2))=ABS($A$2:$A$21-$I2))*$A$2:$A$21)}
数组公式
---------------------------
如图数据;
ABS($A$2:$A$21-$I2)
返回数组 {8.6,7.6,6.6,5.6,4.6,3.6,2.6,1.6,0.6,0.4,1.4,2.4,3.4,4.4,5.4,6.4,7.4,8.4,9.4,10.4}
MIN(ABS($A$2:$A$21-$I2))
返回数值 0.4
MIN(ABS($A$2:$A$21-$I2))=ABS($A$2:$A$21-$I2)
返回数组{FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,TRUE,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE}
(MIN(ABS($A$2:$A$21-$I2))=ABS($A$2:$A$21-$I2))*$A$2:$A$21
返回数组{0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,3.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0}
=MAX((MIN(ABS($A$2:$A$21-$I2))=ABS($A$2:$A$21-$I2))*$A$2:$A$21)
返回数值 3