符號判斷 取值 (14711)

E2:F14{=IFERROR(CHOOSE(LOOKUP(1,-FIND({"±","~"},$D2),{1,2}),MAX(IFERROR(--MID($D2,FIND("±",$D2)+1,ROW($1:$9)),))*-1^(D$1=$D$1),LOOKUP(10^9,--MID($D2,FIND("~",$D2)+(-ROW($1:$9)*-1^(D$1=$C$1))^(D$1=$D$1),ROW($1:$9)))),"")