EXCEL 里面 如果值为A,B,C,D,E 那么等于1;如果值为F,G,H,I,K那么等于2,怎么设置公式
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/24 17:11:00
![EXCEL 里面 如果值为A,B,C,D,E 那么等于1;如果值为F,G,H,I,K那么等于2,怎么设置公式](/uploads/image/z/2573280-0-0.jpg?t=EXCEL+%E9%87%8C%E9%9D%A2+%E5%A6%82%E6%9E%9C%E5%80%BC%E4%B8%BAA%2CB%2CC%2CD%2CE+%E9%82%A3%E4%B9%88%E7%AD%89%E4%BA%8E1%EF%BC%9B%E5%A6%82%E6%9E%9C%E5%80%BC%E4%B8%BAF%2CG%2CH%2CI%2CK%E9%82%A3%E4%B9%88%E7%AD%89%E4%BA%8E2%2C%E6%80%8E%E4%B9%88%E8%AE%BE%E7%BD%AE%E5%85%AC%E5%BC%8F)
EXCEL 里面 如果值为A,B,C,D,E 那么等于1;如果值为F,G,H,I,K那么等于2,怎么设置公式
EXCEL 里面 如果值为A,B,C,D,E 那么等于1;如果值为F,G,H,I,K那么等于2,怎么设置公式
EXCEL 里面 如果值为A,B,C,D,E 那么等于1;如果值为F,G,H,I,K那么等于2,怎么设置公式
=if(or(A1="A",A1="B",A1="C",A1="D",A1="E"),1,if(or(A1="F",A1="G",A1="H",A1="I",A1="K"),2,""))
或者
=lookup(A1,{"A","B","C","D","E","F","G","H","I","K"},{1,1,1,1,1,2,2,2,2,2}
再或者
=IF(MATCH(A1,{"A","B","C","D","E","F","G","H","I","K"},0)>5,2,1)
这都假设是没有其他情况的