作者:
h02158 (阿益)
2023-05-19 12:15:34軟體: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
作者:
ahwii (ahwii)
2023-05-20 12:03:00=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)