ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] EXCEL IF¨ç¼Æ ºÃ°Ý ½Ö¯àÀ°§Ú¸Ñµª

[µo°Ý] EXCEL IF¨ç¼Æ ºÃ°Ý ½Ö¯àÀ°§Ú¸Ñµª

À°§Ú¬Ý¬Ý¦³¨S¦³¿ù»~

¥¼©R¦W.JPG
2012-11-2 08:57


001.rar (5.24 KB)



³oexcel½Ö¯àÀ°À°§Ú


¬°¤°»ò§Ú¨Ï¥ÎIF¨ç¼Æ

¦³±ø¥ó¤F¡AÀx¦s®æ¨S¦³ªF¦è¡A¦ý¬OÁÙ¬OÅã¥Ü¥X¤å¦r¨Ó

³o¸Ó³o»ò³B²z???

³Â·Ð¦U¦ì¤j¤j¤F

§Ú­n¦p¦óÅý ¼Ð°O¨ºÃä ¡A
«e­±¨S¼Æ­È®É¡A¤£Åã¥Ü

TOP

¦^´_ 1# keovin790916


    M3=IF(L3="","",IF(L3>15%,"¤jº¦",IF(L3<-15%,"¤j¶^",IF(L3>5%,"º¦",IF(L3<-5%,"¶^",IF(L3<5%>-5%,"«ù¥­"))))))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

M3,

=IF(L4="","",LOOKUP(L4,{-9.9E+307;-0.15;-0.05;0.06;0.16},{"¤j¶^";"¶^";"«ù¥­";"º¦";"¤jº¦"}))

¤½¦¡¦V¤U½Æ»s

TOP

©ÎªÌ :

=IF(L4="","",CHOOSE(MATCH(L4,{-9.9E+307,-0.15,-0.05,0.06,0.16}),"¤j¶^","¶^","«ù¥­","º¦","¤jº¦"))

TOP

¦^´_ 6# keovin790916
©ÎªÌ :
=IF(L3="","",INDEX({"¤j¶^","¶^","«ù¥­","º¦","¤jº¦"},MATCH(L3,{-9.9E+307,-0.15,-0.05,0.06,0.16})))

TOP

¦^´_ 6# keovin790916


©ÎªÌ :

=IF(L3="","",VLOOKUP(L3,{-9.9E+307,"¤j¶^";-0.15,"¶^";-0.05,"«ù¥­";0.06,"º¦";0.16,"¤jº¦"},2))

TOP

¦^´_ 6# keovin790916

©ÎªÌ :

=IF(L3="","",HLOOKUP(L3,{-9.9E+307,-0.15,-0.05,0.06,0.16;"¤j¶^","¶^","«ù¥­","º¦","¤jº¦"},2))

TOP

¦^´_ 3# Hsieh


«á­± ³o¤@¬q IF(L3<5%>-5%,"«ù¥­") ¬Ý°_¨Ó©Ç©Çªº
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 9# ML089
§Úªº¥Î·N¥u¦b²Ä¤@­ÓIF
©Ò¦³§PÂ_±ø¥ó¨Ã¥¼¥[¥H§ó¥¿
¥D­n»¡©úIF¨ç¼Æ·|¥H±ø¥ó¥ý«á¦¨¥ßªº¶¶§Ç¶Ç¦^µ²ªG
¦pªG­ì¨Óªº¤½¦¡µL»~¡A­n¶Ç¦^ªÅ¥Õ¡A¥u»Ýª½±µ¥[¤@¼hIF§Y¥i
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD