excel当A1大于等于88市B1为A,当A1大于等于80小于88时,B1为B,当A1大于80小于等于70时怎么设置公式?
相似回答
excel如何设置,当A1大于等于110时,B1输出A。当A1大于等于100小于110时输...答:满意请采纳。=IF(A1>=110,"A",IF(A1>=100,"B",IF(A1>=80,"C",IF(A1>=70,"D","E")))
excel大于等于90显示a答:,IF(A1<90,"C",IF(A1<100,"B","A")))如果你使用的是Office 2019或是Office 365,还可以使用IFS函数,让公式短一截:=IFS(A1<60,"F",A1<70,"E",A1<80,"D",A1<90,"C",A1<100,"B",1,"A")...
excel 函数问题 A1大于等于80小于等于100则A1等于B1,A1大于100小于等于1...答:那么可以在C1输入 【=IF(80<=A1<=100,B1,IF(100<A1<=150,A1*B1,"请输入有效值"))】改为【=IF(80<=A1<=100,B1,IF(OR(100<A1<=150,A1<80),A1*B1,"请输入有效值"))】从你的描述中,给你普及一下,当...