[算表] 判斷式公式

[h02158 ()]

軟體:Excel

版本:2016


如下圖,我想在E6欄位下公式，
7~9=A ,4~6=B,3=C
A=3,B=2,C=1
所以我在E6欄位得到答案是A (B(2)+A(3)+A(3)=8)
請哪位大大能幫忙..謝謝！
https://i.imgur.com/QDaRuaF.jpg

--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 223.136.178.123 (臺灣)
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1684469736.A.538.html
推 milk0330: https://i.imgur.com/LOm6XfN.jpg
→ h02158: 謝謝m大大！
→ ahwii: =LOOKUP(SUM(3-(CODE(A2:C2)-65)),{0,4,7},{"C","B","A"})
→ ahwii: =CHOOSE(SUM((CODE(A2:C2)-65))/3+1,"A","B","C")
→ ahwii: =CHAR(SUM(CODE(A2:C2))/3)