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

keovin790916

¤U¸ü (117.62 KB)
À°§Ú¬Ý¬Ý¦³¨S¦³¿ù»~

2012-11-2 08:57

001.rar (5.24 KB)

³øªíÀÉ®×
¤U¸ü¦¸¼Æ: 5

2012-11-2 08:59

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


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

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

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

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

Hsieh

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

ML089

¦^´_ 3# Hsieh


«á­± ³o¤@¬q IF(L3<5%>-5%,"«ù¥­") ¬Ý°_¨Ó©Ç©Çªº

JBY

¦^´_ 6# keovin790916

©ÎªÌ :

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

JBY

¦^´_ 6# keovin790916


©ÎªÌ :

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

JBY

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

JBY

©ÎªÌ :

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

JBY

M3,

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

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

Hsieh

¦^´_ 1# keovin790916


    M3=IF(L3="","",IF(L3>15%,"¤jº¦",IF(L3<-15%,"¤j¶^",IF(L3>5%,"º¦",IF(L3<-5%,"¶^",IF(L3<5%>-5%,"«ù¥­"))))))

keovin790916

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