求EXCEL公式解释什么意思=MAX((MIN(ABS($A$2:$A$21-$I2))=ABS($A$2:$A$21-
来源:学生作业帮 编辑:搜搜考试网作业帮 分类:综合作业 时间:2024/07/28 13:27:06
求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)最后一步是取出最大值
按照步骤能否理解为
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-](/uploads/image/z/8351948-20-8.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-)
{=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
![](http://img.wesiedu.com/upload/b/47/b47d9fb09893636342c506f6768066e4.jpg)
数组公式
---------------------------
如图数据;
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
![](http://img.wesiedu.com/upload/b/47/b47d9fb09893636342c506f6768066e4.jpg)
求EXCEL公式解释什么意思=MAX((MIN(ABS($A$2:$A$21-$I2))=ABS($A$2:$A$21-
int val = ((a+b) + abs(a-b))/2; // val是 max 还是 min
matlab [a,l] = max(abs(B(k:n,k)))中a,l分别代表什么?
ABS(a-b+c)+ABS(a-b-c)=
EXCEL中ABS(-1)-ABS(-1)=-2 ABS不是绝对值的意思吗?
matlab中,a是复数,a=1+2*i,abs(a)是求a的模值,那a的相位用什么命令求呢
matlab中2*min(a,b)*cos(x*pi))+abs(a-b)是什么意思
=IF(ABS(MAX(J13:O13))>ABS(MIN(J13:O13)),MAX(J13:O13),MIN(J13
对于一个矩阵A,用Matlab输入[m j]=max(abs(A)),c=A(j),
关于EXCEL公式,=IF(A6>=1,ROUND(ABS(SUMIF($A$5:$A6,">=1",$G$5:$G6)
excel如何自动填充:C1=ABS(A2/A1-B2/B1);C2=ABS(A3/A1-B3/B1);C3=ABS(A
若方程9^(-abs(2-x))-4*3^(-abs(2-x))+a=0有实数根、求a的范围