XY軸 9 種判斷 (15321)

D2=CHOOSE(SIGN(B2*C2)+2,"第 "&IF(B2>0,4,2)&" 象限",CHOOSE(SUMPRODUCT(TEXT(SIGN(B2:C2),"1;3;0")*1)+(B2<>0)+1,"中心","Y上","X右","Y下","X左"),"第 "&IF(B2<0,3,1)&" 象限")



留言