返回列表 上一主題 發帖

[發問] EXCEL IF函數 疑問 誰能幫我解答

M3,

=IF(L4="","",LOOKUP(L4,{-9.9E+307;-0.15;-0.05;0.06;0.16},{"大跌";"跌";"持平";"漲";"大漲"}))

公式向下複製

TOP

或者 :

=IF(L4="","",CHOOSE(MATCH(L4,{-9.9E+307,-0.15,-0.05,0.06,0.16}),"大跌","跌","持平","漲","大漲"))

TOP

回復 6# keovin790916
或者 :
=IF(L3="","",INDEX({"大跌","跌","持平","漲","大漲"},MATCH(L3,{-9.9E+307,-0.15,-0.05,0.06,0.16})))

TOP

回復 6# keovin790916


或者 :

=IF(L3="","",VLOOKUP(L3,{-9.9E+307,"大跌";-0.15,"跌";-0.05,"持平";0.06,"漲";0.16,"大漲"},2))

TOP

回復 6# keovin790916

或者 :

=IF(L3="","",HLOOKUP(L3,{-9.9E+307,-0.15,-0.05,0.06,0.16;"大跌","跌","持平","漲","大漲"},2))

TOP

        靜思自在 : 修行要繫緣修心,藉事練心,隨處養心。
返回列表 上一主題