[µo°Ý] ¦h±ø¥ó­pºâ¶ñ¤J¦r¦ê

jj369963

¦pÃD
·Q­n¦bEÄæ¥Î¤½¦¡¶ñ¼g³W«h¡A¦Û°Ê¶ñ¤J¤ÀÃþ¨ìªº¶µ¥Ø
¼g¨ì¤@¥b¤£ª¾«ç¼g

¦A³Â·Ð«ü¥Ü¤@¤U
ÁÂÁ ¦h±ø¥ó­pºâ.rar (235.16 KB)

¤U¸ü¦¸¼Æ: 11

2020-2-28 18:54

jj369963

¦^´_ 1# jj369963

¥Ø«e¼g¥X¨Ó
=IF(AND((A2>0)*(B2<0)*(D2>1)=1),"¨üÅwªï",IF(AND((A2<0)*(B2>0)*(D2<-1)=1),"³Q©Úµ´",IF(AND((A2<0)*(B2<0)*(C2<-1)=1),"³Q©¿µø",IF(AND((A2>0)*(B2>0)*(C2>1)=1),"¨üª§Ä³",IF(AND((-1<D2<1)*(-1<C2<1)=1),"¥­§¡²Õ")))))

¦ý¬O"¥­§¡²Õ"ªºÄæ¦ì³£·|¥X¿ù¡A¦A·Ð½Ð±Ð

cucu

¦^´_ 2# jj369963

¸Õ¸Õ¬Ý
    =IF(AND((A2>0)*(B2<0)*(D2>1)=1),"¨üÅwªï",IF(AND((A2<0)*(B2>0)*(D2<-1)=1),"³Q©Úµ´",IF(AND((A2<0)*(B2<0)*(C2<-1)=1),"³Q©¿µø",IF(AND((A2>0)*(B2>0)*(C2>1)=1),"¨üª§Ä³",IF(AND((D2<1)*(D2>-1)*(C2<1)*(C2>-1)=1),"¥­§¡²Õ")))))

jj369963

¦^´_ 3# cucu
ÁÂÁ¡A¤w¦¨¥\¡C
·Q­n½Ð±Ð¦pªG´«¦¨vlookup¨Ó¼g¡AÀ³¸Ó«ç»ò¼g¡H
ÁÂÁÂ

cucu

¦^´_ 4# jj369963

¤p§Ì¥\¤O¤£¨¬¡A³oÃD§ÚµLªk¥Îvlookup©Î¨ä¥L¬dªíªº¤è¦¡°µ¥X¨Ó¡A¬Ý¬Ý¦³¨S¦³°ª¤â¯à«ü¾É¤@¤U¡C
¦pªG±z¦³IFS¨ç¼Æ¥i¥H¥Î¡A§Úı±oÁÙºâ¬O®¼¤è«Kªº¡C
=IFS((A2>0)*(B2<0)*(D2>1),"¨üÅwªï",(A2<0)*(B2>0)*(D2<-1),"³Q©Úµ´",(A2<0)*(B2<0)*(C2<-1),"³Q©¿µø",(A2>0)*(B2>0)*(C2>1),"¨üª§Ä³",(D2>-1)*(D2<1)*(C2>-1)*(C2<1),"¥­§¡²Õ")