軟體: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

謝謝m大大！

=LOOKUP(SUM(3-(CODE(A2:C2)-65)),{0,4,7},{"C","B","A"})=CHOOSE(SUM((CODE(A2:C2)-65))/3+1,"A","B","C")=CHAR(SUM(CODE(A2:C2))/3)