作者:乔山办公网日期:
返回目录:excel表格制作
在I3单元格写上公式:
=if(H3<60,"不合格",IF(H3<80,"合格",IF(H3<90,"良好","优秀")))
公式如下:
=LOOKUP(C2,{0,51,101,151,201,251},{"优","良","轻度","中度","重度","严重"})
B2输入复=IF(OR(AND(A1=1,OR(A2={0,1,2,5,6,7})),AND(A1=2,OR(2={1,2,3,6,7,8})),AND(A1=3,OR(A2={2,3,4,7,8,9})),AND(A1=4,OR(A2={3,4,5,8,9,0})),AND(A1=5,OR(A2={4,5,6,9,0,1})),AND(A1=6,OR(A2={5,6,7,0,1,2})),AND(A1=7,OR(A2={6,7,8,1,2,3})),AND(A1=8,OR(A2={7,8,9,2,3,4})),AND(A1=9,OR(A2={8,9,0,3,4,5})),AND(A1=0,OR(A2={9,0,1,4,5,6}))),"对制","")回车。zhidao
单个指标你会用,那你就比较四个单项指标,取最大值就可以了,思路是
=max(指标1结果,指标2结果,指标3结果,指标4结果)
做公式时候把大写的等级用小写数字代替