数值范围之间比较的函数怎么写

773246184 · 发表于 2023-7-30 17:41

如图，如果I列小于或大于J列参考区间的值分别用↓和↑标记，这个函数能直接写吗

风雨声点滴 · 发表于 2023-7-30 18:09

=IF(I3<1*LEFT(J3,FIND("-",J3)-1),"↓",IF(I3>1*RIGHT(J3,FIND("-",J3)-1),"↑",""))

quqiyuan · 发表于 2023-7-30 18:22

=IF(I1<--TEXT(1%,SUBSTITUTE(J1,"--",";")),"↓",IF(I1>--TEXT(-1%,SUBSTITUTE(J1,"--",";")),"↑",""))

773246184 · 发表于 2023-7-30 18:59

风雨声点滴发表于 2023-7-30 18:09
=IF(I31*RIGHT(J3,FIND("-",J3)-1),"↑",""))

学习学习，谢谢大佬

773246184 · 发表于 2023-7-30 18:59

quqiyuan 发表于 2023-7-30 18:22
=IF(I1--TEXT(-1%,SUBSTITUTE(J1,"--",";")),"↑",""))

学习学习，谢谢大佬

冬不暖 · 发表于 2023-7-30 19:32

=IF(I1<IMREAL(SUBSTITUTE(J1,"--","-")&"i"),"↓",IF(I1>-IMAGINARY(SUBSTITUTE(J1,"--","-")&"i"),"↑",""))

复制代码

橒♂蝣 · 发表于 2023-7-30 20:09

=if(i1<--(mid(j1,1,find("-",j1)-1),"↓",if(i1>mid(j1,1,find("-",j1)+2,"↑","")

xlllw203 · 发表于 2023-7-31 09:37

本帖最后由 xlllw203 于 2023-7-31 09:50 编辑

=IFERROR(VLOOKUP(SUM(--TEXT(TEXT({1,-1}%,SUBSTITUTE(J1,"--",";"))-I1,"1;-1;0;")),{-2,"↑";2,"↓"},2,),"")

复制代码

=CHAR(MAX(FREQUENCY(I1,--TEXT({1;-1}%,SUBSTITUTE(J1,"--",";")))*{41469;32;41468}))

复制代码

jivy1212 · 发表于 2023-7-31 10:00

复制代码

单元格自己改

		自动登录	找回密码
密码			免费注册

[求助] 数值范围之间比较的函数怎么写