1.比如在成绩登记中,要使60分以下为红色,60分以上为黑色并取整数,在自定义格式中写入:[>=60][黑色]0;[<60][红色]0确定即可.
2.IF(B2>89,"A",IF(B2>79,"B",IF(B2>69,"C",IF(B2>59,"D","F"))))
if(A2<60,“不及格”,if(A2<=90,“及格”,“优秀"))
1.比如在成绩登记中,要使60分以下为红色,60分以上为黑色并取整数,在自定义格式中写入:[>=60][黑色]0;[<60][红色]0确定即可.
2.IF(B2>89,"A",IF(B2>79,"B",IF(B2>69,"C",IF(B2>59,"D","F"))))
if(A2<60,“不及格”,if(A2<=90,“及格”,“优秀"))