作者h02158 ()
看板Office
标题[算表] 判断式公式
时间Fri May 19 12:15:34 2023
软体: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://webptt.com/cn.aspx?n=bbs/Office/M.1684469736.A.538.html
2F:→ h02158: 谢谢m大大! 05/19 13:43
3F:→ ahwii: =LOOKUP(SUM(3-(CODE(A2:C2)-65)),{0,4,7},{"C","B","A"}) 05/20 12:03
4F:→ ahwii: =CHOOSE(SUM((CODE(A2:C2)-65))/3+1,"A","B","C") 05/20 12:04
5F:→ ahwii: =CHAR(SUM(CODE(A2:C2))/3) 05/20 12:04