正負起止數之間 判斷 (15245)

I2=IF(MEDIAN(E2-D2*E2^ISNUMBER(FIND("%",D2)),G2+D2*G2^ISNUMBER(FIND("%",D2)),H2)=H2,"V","XX")

另解{=IF(MEDIAN(H2,IF({1,0},E2,G2)+{-1,1}*D2*IF({1,0},E2,G2)^ISNUMBER(FIND("%",D2)))=H2,"V","XX")