楼主:
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)